Explore >> Select a destination
|
You are here 
|
savvinov.com | ||
| | | | |
tonyhasler.wordpress.com
|
|
| | | | | Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | [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... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe... | |
| | | | |
afatkulin.blogspot.com
|
|
| | | Take a look at the following table: SQL> create table codes 2 ( 3 code varchar2(10), 4 used number, 5 constraint pk_cod... | ||
