Method R Discussion Group

Method R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle.

Discuss Method R products, techniques, and events.

Ask new questions or post your own responses.

Enabling Trace with Parallel Auto Tuning - Webinar 2/26/08

How do you enable trace if parallel_automatic_tuning = true?
Becky Goodman Send private email
Tuesday, February 26, 2008
 
 
Same as you would without it.  The only tricky part is that if you use DBMS_SUPPORT or DBMS_MONITOR the slave processes will not get traced.  If you want the slave processes traced then you will need to turn on trace with alter session set events 10046 trace name context forever, level 12.  Then the slaves will get traced. (Same issue with shared servers.)
Ric Van Dyke Send private email
Wednesday, February 27, 2008
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Discussion Groups Main Page

Powered by FogBugz