This content has been marked as final. Show 3 replies
Does anyone has any news on this thread?
this does not seem to be a security related issue. While the scheduler may know the notion of 'chains' the sql_trace facility
has no understanding of inheritance, so to gather trace info build it into the jobs so they can set event 10046 in their
respective job sessions. Also if you generate an AWR report for the duration of the jobs, you may be able to pinpoint
certain sql statements using more resources, compare with AWR report for the 'normal' situation,
Harm ten Napel
If possible try to generate AWR report & check. It will show you all detail about SQLs.