What Two Stocks Have Had Dividend Increases for Over 55 Years?
Trade Ideas For Friday, March 11
The Rush To Blame The Right + More
The Patriot Post Chronicle The Foundation “We must take human nature as we find it, perfection falls not to the share of mortals.” –George Washington Editorial Exegesis “The Tucson shooting was an unspeakable horror, [as] a characteristic exercise in American democracy — a townhall meeting outside a Safeway store — [was] interrupted by gunshots and [...]
Licensing Requirements for SQL ProfilesJonathan Lewis reminded me on my last post that using SQL Profiles (because they are part of the SQL Tuning Advisor) requires a license for Oracle Tuning Pack (which requires a license for the Diagnostics Pack). He also mentioned that Baselines did not require any additional license (at least creating and using Baselines on SQL statements). It’s been a while since I worked on a database that didn’t have both Packs, but Frankly I wasn’t sure I had a good handle of what was allowed and what wasn’t so I thought it might be worthwhile to check. There is an easy way to check by the way. I did a post a while back on Tuning Pack and Diagnostic Pack license requirements for running AWR and how to check what was allowed and what wasn’t using the CONTROL_MANAGEMENT_PACK_ACCESS parameter. Here’s a link to the post:
Here’s an example using the same technique to show that SQL Profiles are indeed disabled by turning off the Diagnostic and Tuning Packs (at least one 11.2.02).
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 7 21:15:21 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SYS@SANDBOX1> @parms Enter value for parameter: management_pack Enter value for isset: Enter value for show_hidden: NAME VALUE ISDEFAUL ISMODIFIED ISSET -------------------------------------------------- ---------------------------------------------------------------------- -------- ---------- ---------- control_management_pack_access DIAGNOSTIC+TUNING TRUE TRUE TRUE SYS@SANDBOX1> @flush_pool System altered. SYS@SANDBOX1> @avgskew AVG(PK_COL) ----------- 16093748.8 1 row selected. SYS@SANDBOX1> / AVG(PK_COL) ----------- 16093748.8 1 row selected. SYS@SANDBOX1> @dplan Enter value for sql_id: 05cq2hb1r37tr Enter value for child_no: PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID 05cq2hb1r37tr, child number 0 ------------------------------------- select avg(pk_col) from kso.skew a where col1 > 0 Plan hash value: 568322376 ----------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 44486 (100)| | | 1 | SORT AGGREGATE | | 1 | 11 | | | |* 2 | TABLE ACCESS STORAGE FULL| SKEW | 32M| 335M| 44486 (1)| 00:08:54 | ----------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - storage("COL1">0) filter("COL1">0) Note ----- - SQL profile PROF_05cq2hb1r37tr_568322376 used for this statement 24 rows selected. SYS@SANDBOX1> @flush_pool System altered. SYS@SANDBOX1> alter system set control_management_pack_access='none'; System altered. SYS@SANDBOX1> @avgskew AVG(PK_COL) ----------- 16093748.8 1 row selected. SYS@SANDBOX1> / AVG(PK_COL) ----------- 16093748.8 1 row selected. SYS@SANDBOX1> @dplan Enter value for sql_id: 05cq2hb1r37tr Enter value for child_no: PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID 05cq2hb1r37tr, child number 0 ------------------------------------- select avg(pk_col) from kso.skew a where col1 > 0 Plan hash value: 568322376 ----------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 44486 (100)| | | 1 | SORT AGGREGATE | | 1 | 11 | | | |* 2 | TABLE ACCESS STORAGE FULL| SKEW | 32M| 335M| 44486 (1)| 00:08:54 | ----------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - storage("COL1">0) filter("COL1">0) 20 rows selected. SYS@SANDBOX1> alter system set control_management_pack_access='DIAGNOSTIC+TUNING'; System altered. SYS@SANDBOX1> @flush_pool System altered. SYS@SANDBOX1> @avgskew AVG(PK_COL) ----------- 16093748.8 1 row selected. SYS@SANDBOX1> / AVG(PK_COL) ----------- 16093748.8 1 row selected. SYS@SANDBOX1> @dplan Enter value for sql_id: 05cq2hb1r37tr Enter value for child_no: PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID 05cq2hb1r37tr, child number 0 ------------------------------------- select avg(pk_col) from kso.skew a where col1 > 0 Plan hash value: 568322376 ----------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 44486 (100)| | | 1 | SORT AGGREGATE | | 1 | 11 | | | |* 2 | TABLE ACCESS STORAGE FULL| SKEW | 32M| 335M| 44486 (1)| 00:08:54 | ----------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - storage("COL1">0) filter("COL1">0) Note ----- - SQL profile PROF_05cq2hb1r37tr_568322376 used for this statement 24 rows selected.So as you can see, there was a SQL Profile on the statement that was used when Diagnostic and Tuning Packs were enabled, but when I set CONTROL_MANAGEMENT_PACK_ACCESS to NONE, the SQL Profile was ignored. Let’s try the same test with a Baseline.
SYS@SANDBOX1> @flush_pool System altered. SYS@SANDBOX1> @avgskew AVG(PK_COL) ----------- 16093748.8 SYS@SANDBOX1> @create_baseline Enter value for sql_id: 05cq2hb1r37tr Enter value for plan_hash_value: 568322376 Enter value for fixed (NO): Enter value for enabled (YES): Enter value for plan_name (SQLID_sqlid_planhashvalue): sql_id: 05cq2hb1r37tr plan_hash_value: 568322376 fixed: NO enabled: YES Baseline SQLID_05cq2hb1r37tr_568322376 created. PL/SQL procedure successfully completed. SYS@SANDBOX1> @avgskew AVG(PK_COL) ----------- 16093748.8 SYS@SANDBOX1> / AVG(PK_COL) ----------- 16093748.8 SYS@SANDBOX1> @dplan Enter value for sql_id: 05cq2hb1r37tr Enter value for child_no: PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID 05cq2hb1r37tr, child number 0 ------------------------------------- select avg(pk_col) from kso.skew a where col1 > 0 Plan hash value: 568322376 ----------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 44486 (100)| | | 1 | SORT AGGREGATE | | 1 | 11 | | | |* 2 | TABLE ACCESS STORAGE FULL| SKEW | 32M| 335M| 44486 (1)| 00:08:54 | ----------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - storage("COL1">0) filter("COL1">0) Note ----- - SQL profile PROF_05cq2hb1r37tr_568322376 used for this statement - SQL plan baseline SQLID_05CQ2HB1R37TR_568322376 used for this statement 25 rows selected. SYS@SANDBOX1> -- so Baseline and SQL Profile Used SYS@SANDBOX1> SYS@SANDBOX1> alter system set control_management_pack_access='none'; System altered. SYS@SANDBOX1> @flush_pool System altered. SYS@SANDBOX1> @avgskew AVG(PK_COL) ----------- 16093748.8 SYS@SANDBOX1> / AVG(PK_COL) ----------- 16093748.8 SYS@SANDBOX1> @dplan Enter value for sql_id: 05cq2hb1r37tr Enter value for child_no: PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID 05cq2hb1r37tr, child number 0 ------------------------------------- select avg(pk_col) from kso.skew a where col1 > 0 Plan hash value: 568322376 ----------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 44486 (100)| | | 1 | SORT AGGREGATE | | 1 | 11 | | | |* 2 | TABLE ACCESS STORAGE FULL| SKEW | 32M| 335M| 44486 (1)| 00:08:54 | ----------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - storage("COL1">0) filter("COL1">0) Note ----- - SQL plan baseline SQLID_05CQ2HB1R37TR_568322376 used for this statement 24 rows selected.So Baselines apparently do not require licenses for the Tuning and Diagnostics Packs, at least they aren’t disabled by setting the CONTROL_MANAGEMENT_PACK_ACCESS parameter to NONE.
Tickers for the Current Reshaping
I am still trying to get my portfolios entirely transferred from Fidelity, and I am on try #4 now. I think it will work. Beyond that, I am registering in Texas, which is now my second state after Maryland. As for Maryland, when I registered, I goofed by not registering myself as a CFA Charterholder; [...]
White Paper: Advantages of Multi-rate Harmonic Balance Technology
AWR recently published a new white paper, The Advantages of Multi-rate Harmonic Balance Technology. To make harmonic balance analysis viable, AWR has pioneered a multi-rate harmonic balance (MRHB) technology within its APLAC family of harmonic balance and time-domain simulators. The capabilities provided with MRHB make it possible to solve entire complex subsystems such as mobile [...]
Dave Naylor “The Three Pillars of SEO (Advanced) – a4u Live Blogging
Good morning guys! Here is our first bit of liveblogging from the #a4uExpo here in London. We’ll be bringing as much info to you as we can over the course of the day and welcome any feedback or thoughts in the comments! Our first post is about a presentation from Dave Naylor of Bronco SEO. Dave’s [...]
advanced web ranking for real estate
After a longer break we are back at expanding the Aspen Real Estate BLOG. Expect news and useful information on everything Aspen real estate on a regular basis at this spot.We will start with a very exciting product that is most useful for real estate agents and active real estate webmasters. The product I would like to review is called “Advanced Web Ranking” by Caphyon. When I began having the idea about utelizing the latest technology in my website to service my real estate clients and to attract new interested customers I knew that I needed to know how well my site would be doing in the search rankings at various search engines. Why use a search engine ranking tool? True this process of finding a search engine rank can be done manually by just looking at a search term, lets say “Aspen Real Estate” and then weeding through pages of search results to dig for one’s own website. Then counting what place from the top one is located. You can already see that this is a very tedious way of gathering this important information. Let alone trying to figure out these statistics for dozens of key phrases in multiple search engines on a daily basis and keeping track of the results. Automated search engine ranking is the basis of good search engine optimization. What is Advanced Web Ranking? This is where Advanced Web Ranking comes in. Advanced Web Ranking (AWR) is a market leading tool for performing and automating search engine rankings. The software runs on a Mac just as well as on Windows computers so the computer market is almost 100% covered. During the several years that I have been using the software I found that it is regularly updated. Not only are new features implemented on a constant basis but bug fixes are implemented very swiftly. The software is also updated regularly for changes in the search protocols of various search engines so that Advanced Web Rankings stays on top of constantly changing search engine optimization game. The purchase of the software comes with a maintenance plan that offers these updates for free for the first year. After that Caphyon offers the update extension on the basis of annual update plans at a cost. The basics: How to use the software Advanced Web Ranking has a clean user interface. After specifying the website(s) in question the user can input a list of relevant keywords or key phrases that are of interest. Advanced Web Ranking also offers a keyword suggestion tool that is helpful to find the first keywords. Once all desired keywords are specified and the relevant search engines have been selected, Advanced Web Ranking takes over and scans the search engines for your site’s ranking. This is where it gets interesting. It is almost an addiction to run the software to find out if one’s site has increased in the search engine ranks. Has the latest SEO strategy worked or was it even counter productive? How much lag is there between initiating a SEO campaign and the first results? With the easy to digest charts and ranking tables it is intuitive to see long term trends in site rank, but nothing is as exciting than to see a big jump in the top keyword at google and knowing that the hard work has paid off. A full feature list for website ranking can explain the different option one has with this tool. How about competitor analysis? The search results will not only give you your site’s ranking with the selected search engines but also your competitor’s ranking. This allows you to sample your most successful competitors and learn from their performance. Charts give you your ranking over all search terms versus your competitors. Learn who is moving up and who is falling behind. This kind of knowledge really makes all the difference in my efforts to attract more site visitors. Charts over time? It is also very easy to track your rankings over time. AWR will show the ranking position of your site for various keywords in graphical format. This allows the user to detect trends in the site’s performance and shows the overall picture of the sites ranking changes over time. No spreadsheet can compete with the power of a chart showing me my rankings over several time periods. Has something changed over the last few days? When was the last big jump in site rankings? All of the se questions are answered by AWR. How long does this all take? The AWR program takes only a few minutes to run for a few dozen keywords on the main search engines. For larger keyword searches and a large quantity of search engines, Advances Web Rankings can automatically be scheduled to run overnight. Reports? Several output options are available. PDF reports for corporate clients can be produced and very professional presentations are available at a click of a button. AWR even offers to automatically send reports to a selected email list of clients or partners. It is very convenient to have these reports available to document the success of Search Engine Optimization work to co-workers or clients. Gathering information is one thing but AWR also shines when it comes to processing that information and automatically generating picture perfect reports. For a comparison of the different versions of Advanced Web Rankings have a look following the link. Conclusion ! Overall I have not found a competing keyword research tool that offers the ease of use combined with the complete array of powerful features that Advanced Web Ranking offers. I can fully recommend this software on the basis of several years of daily usage of Advanced Web Rankin.
Advanced Web Ranking: the most accurate way to monitor rankings
Over the years we’ve tried dozens of ways to monitor rankings on the major search engines and none of them have ever been able to deliver accurate results, apart from Advanced Web Ranking. I have very little patience with rank checkers that don’t show accurate search engine rankings because there is no point in reporting on [...]Not getting the rankings you want? Hire us for Search engine optimisation
Advanced Web Ranking: the most accurate way to monitor rankings
Stocks To Watch Next Week
Search Engine Ranking Checkers – Why They Still Matter
A post about search engine ranking checkers, organic SEO monitoring and the need to track many long tail keywords.
What Google thinks of American States Water Company
Seasonality Analysis of AWR
Historical data for AWR
American States Water Company at ValueWiki
Experimental Head and Shoulders chart patterns identified today
Experimental Inverted Head and Shoulders chart patterns identified today
Stocks with Positive Correlation to AWR
Stocks with Negative Correlation to AWR
Previous symbol is AWPYX
Next symbol is AWRCF