Home » RDBMS Server » Performance Tuning » SQL Trace on Parallel Session - Help Please?
SQL Trace on Parallel Session - Help Please? [message #65237] Thu, 24 June 2004 17:58 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Everyone,

 

I am having trouble performing a sql trace on sessions running in parallel.

 

If I simply run a sql trace on the parent process, I have nothing on the output of tkprof because this process is not actually doing any work.

I also dont want to enable a sql trace manually by hand for every parallel process running ... too difficult and requires programming.

 

Is there any option in sql trace that allows Oracle to trace a session and its parallel slaves so that I can see what is actually happening?

 

Thanks ... IA
Re: SQL Trace on Parallel Session - Help Please? [message #65276 is a reply to message #65237] Thu, 15 July 2004 02:40 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

You can trace parallel query slave execution with the following event:

alter session set events '10390 trace name context forever, level 1';


Best regards.

Frank
Re: SQL Trace on Parallel Session - Help Please? [message #65348 is a reply to message #65276] Fri, 13 August 2004 04:22 Go to previous message
IA
Messages: 91
Registered: March 2004
Member
Hi Frank,

How does the above statement work and what does it mean?

Does this mean that if I trace a parent session, or any slave process, the trace will show all slaves ??

Also, in which session do I perform the above command?

Sorry about all the questions ... but I am very interested in performing this trace correctly.

Your help is appreciated ... Thanks IA
Previous Topic: control file sequential read - what is it?
Next Topic: Can PeopleToos 8.16 and 8.18 run at same time on same machine
Goto Forum:
  


Current Time: Wed Sep 23 12:18:39 CDT 2020