This discussion is archived
3 Replies Latest reply: Oct 10, 2012 11:29 PM by SanjayPatel RSS

TRACE SESSION X TRACE USER (11gr2)

user11969939 Newbie
Currently Being Moderated
Hi,

We are facing performance isues on a Windows 2008 Oracle database (11.2.0.2) SAP BI Loads. There is a huge chain of jobs that are started and runs on the database with talkes a long time to execute. Let's supose that in this chain there are 500 jobs inside and takes more ou less than 15 to 20 hours. But, sometimes, this time increases and takes 30, 35, 40 hours.
So, we need to understand in which steps of the chain it takes more time, and one of the activities that we are planing is to trace all the execution and identify the waits.

The problem is:

. If there is a "father" process that call's the others, it would be easy since we could set the trace in this session.

Now,

How can we guarantee to trace all the chain since each step is one session opened on the database? Anybody know the usage or viability to trace the user at all? Any other options that could help us in this issue?

Doubt: Even that we set a trace on a "father" session, and this session calls/opens other sessions, this trace would contain all the instructions for all the sessions ou just the father? The trace sees a relation and traces all that are started in parallel?

Please disconsider tracing all the database. Not useful for this situation.

I aprreciate any Help

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points