Home » RDBMS Server » Performance Tuning » Obtaining 10046 Wait Events for Parallel Slaves (10.2.0.4 / Sparc / Solaris)
Obtaining 10046 Wait Events for Parallel Slaves [message #474948] Fri, 10 September 2010 01:42
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
I'm trying to use the following article to get the wait events from Parallel Slave threads in a parallel query http://blogs.oracle.com/db/2010/09/how_to_get_a_10046_trace_for_a_parallel_query.html

But when I go to the user_dump_dest, there is only one trace file for the Query Coordinator, and it doesn't contain the wait events for the slaves.

I'm in a non-RAC environment - just one server, so the trace files for the slaves should not be in some other location.

I have confirmed that the parallel slaves had not already started when I started the trace by running ps -fu oracle in Unix and looking for the PNNN processes.

Anyone know how to get the parallel slaves generating trace files?
Ross Leishman

Report message to a moderator

Previous Topic: Same plan, same data but different performance results
Next Topic: Is there a better way to rewrite this query?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 30 06:16:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.