/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 jhdba.wordpress.com
Automatically running sql_advisor tasks from ADDM reports « Oracle DBA - A lifelong learning experience
| | blog.yannickjaquier.com
SQL Plan Management
2.8 parsecs away

Travel
| | SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile
| | jonathanlewis.wordpress.com
Expanding SQL | Oracle Scratchpad
3.8 parsecs away

Travel
| | Here's a little thing that Dan Morgan mentioned to me some time ago. It's a little routine from a package (owned by sys) that appeared in 11.2.0.3 that gives you some idea of the mess hidden behind a query that uses views. The procedure is called dbms_sql2.expand_sql_text and it takes two (CLOB) parameters: an IN
| | carlos-sierra.net
SQL Stats Analytics (from SQL*Plus!) | Carlos Sierra's Tools and Tips
4.9 parsecs away

Travel
| | If you have access to some other graphical tool that displays time series on multiple dimensions for one or a set of SQL statements from an Oracle database, then you may not need "SQL Stats Analytics". In the other hand, if you have no such tool, or even more restricting, if you can only access...
| | afatkulin.blogspot.com
Alex Fatkulin's Blog: Update and rownum oddity
36.0 parsecs away

Travel
| Take a look at the following table: SQL> create table codes 2 ( 3 code varchar2(10), 4 used number, 5 constraint pk_cod...