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.

Report message to a moderator

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: 20106
Registered: January 2009
Senior Member
alter session set events '10053 trace name context forever;

above will inundate you with details

Report message to a moderator

Previous Topic: Tune Query or Modify Index or Partition
Next Topic: Subquery Transformation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 01:38:09 CDT 2013

Total time taken to generate the page: 0.10757 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.