Re: SQL Plan Management
- From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
- To: "lyallbarbour@xxxxxxxxxxxxxxx" <lyallbarbour@xxxxxxxxxxxxxxx>
- Date: Wed, 2 Oct 2013 17:36:31 +0100
How about an SPM trace on one of the SQL statements at session level and run it
in session or at system level for a specific SQL id?
E.g
Alter session set events 'trace[RDBMS.SQL_Plan_Management.*]';
Or
alter system set events 'trace[RDBMS.SQL_Plan_Management.*] [SQL: 12345abcd]';--
//www.freelists.org/webpage/oracle-l
Other related posts:
