Home » RDBMS Server » Performance Tuning » Is it possible to display alternate execution plans ? (11gR2, win-xp)
Is it possible to display alternate execution plans ? [message #541091] Fri, 27 January 2012 09:29 Go to next message
Rahm
Messages: 11
Registered: July 2011
Junior Member
When we use the AUTOTRACE / EXPLAIN PLAN we can see the (estimated) best execution plan the Optimizer found for our SQL Command.
Is there a way to display all alternate execution plans the Optimizer has considered ?

Thank you.
Re: Is it possible to display alternate execution plans ? [message #541093 is a reply to message #541091] Fri, 27 January 2012 09:31 Go to previous message
BlackSwan
Messages: 22512
Registered: January 2009
Senior Member
alter session set events '10053 trace name context forever;

above will inundate you with details
Previous Topic: Tune Query or Modify Index or Partition
Next Topic: Subquery Transformation
Goto Forum:
  


Current Time: Mon Jul 28 06:24:06 CDT 2014

Total time taken to generate the page: 0.09388 seconds