/explore
|
You are here 
|
blog.tanelpoder.com | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
andreynikolaev.wordpress.com
Oracle 11.2.0.2 contains enhancements 9282521 and 9239863 named Library cache: mutex X" for objects highly contended for. Part I and II. These enhancements introduce new interesting possibilities to tune some types of the mutex contention. Contention for heavily accessed objects can now be divided between multiple copies of object in the library cache. According to |
|
| | | | | ||
| | | | |
tanelpoder.com
I'veupdated some of myASH scriptsto use these 4 arguments in a standard way: What ASH columns to display (and aggregate by) Which ASH rows to use for the report (filter) Time range start Time range end So this means whenever I run ashtop(or dashtop) for example, I need to type in all 4 parameters. The example below would show top SQL_IDs only for user SOE sessions from last hour of ASH samples: - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. |
|
| | | | | ||
| | | | |
www.jvt.me
|
|
| | | |||
