Re: High elapsed/cpu ratio

On 10.09.2007, ebwright_at_gmail.com <ebwright_at_gmail.com> wrote:
> On Sep 10, 3:18 pm, Wiktor Moskwa <wiktorDOTmos..._at_gmail.com> wrote:
>>
>> Was this session traced with wait events information?
>> alter session set events '10046 trace name context forever, level 12'
>
> alter session set events='10046 trace name context forever, level 8'
> This was submitted from the eBusiness Suite concurrent manager with
> Enable SQL Trace
> set to yes for the concurrent program. I'm not sure how I would go
> about running with a different
> level unless I just ran this one statement with appropriate bind
> variables in a separate session.
>

You can run this query in a separate session or as David suggested create statspack snapshots before and after running this query, especially if ther is only one user doing things.

I'm not sure how to enable trace in other session in 9.2, maybe others can suggest.

-- 
Wiktor Moskwa