/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

 hourim.wordpress.com
SQLTXPLAIN under Oracle 12c | Mohamed Houri's Oracle Notes
| | oralytics.com
My first steps with Oracle 12c « Ora-lytics
1.6 parsecs away

Travel
| | Oracle 12c was released just over a week ago and I've finally managed to get round to installing it.This must be the first time that I have done an install of an newly release Oracle Database, where everything worked first time. Typically I have learned from the past and have left it a few months...
| | orastory.wordpress.com
SQL_IDs and baselines | OraStory
1.9 parsecs away

Travel
| | There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID)....
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement
2.3 parsecs away

Travel
| | [AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching.
| | jonathanlewis.wordpress.com
dbms_xplan in 10g | Oracle Scratchpad
12.3 parsecs away

Travel
| [More on dbms_xplan.display_cursor()] If you're using 9i and haven't learned about the dbms_xplan package, then you should take a good look atit right away. It's(usually) a much better wayof getting execution plans from your system thanwriting yourown queries against the plan_table. If you'vebeen using dbms_xplan, and upgraded from 9i to 10g, make sure that you...