| SQL Trace on Parallel Session - Help Please? [message #65237] |
Thu, 24 June 2004 17:58  |
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 #65348 is a reply to message #65276] |
Fri, 13 August 2004 04:22  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
