Outer Web | Explore

Explore >> Select a destination

You are here		kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » Unstable Plans (Oracle Plan Stability/Instability)
\|	\|	www.bobbydurrettdba.com Alerting on plans that change for the worse \| Bobby Durrett's DBA Blog	9.7 parsecs away Travel
\|	\|	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. ...	9.7 parsecs away Travel
\|	\|	blog.yannickjaquier.com SQL Plan Management	10.0 parsecs away Travel
\|	\|	SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile	10.0 parsecs away Travel
\|	\|	rwijk.blogspot.com About Oracle: dbms_xplan.display_cursor	10.7 parsecs away Travel
\|	\|	About Oracle	10.7 parsecs away Travel
\|	\|	blog.jooq.org How to get Oracle execution plans with Starts, E-Rows, A-Rows and A-Time columns - Java, SQL and jOOQ.	67.3 parsecs away Travel
\|		This can probably be found elsewhere as well, but here's a short wrap-up how to get the most out of your execution plans, quickly 1. Be sure the actual rows and time statistics are collected. You can do this with -- login as user sys alter system set statistics_level = all; 2. Execute your bad...	67.3 parsecs away Travel