Explore >> Select a destination
|
You are here 
|
tonyhasler.wordpress.com | ||
| | | | |
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... | |
| | | | |
antognini.ch
|
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | In an earlier articleI described how dbms_xplan.display_cursor() could be used to query memory to find the execution plans (and row source statistics) of recently executed SQL. In 9i, you have to use your own SQL to get the equivalent results. If you do, you should avoid using the "traditional" hierarchical type of query that you... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | I've uploaded a monitoring script that I have worked on: zip. The script alerts you when the optimizer runs a SQL statement with a potentially new and inefficient plan so you can intervene. ... | ||
