Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: High elapsed/cpu ratio
On Sep 10, 3:14 pm, Wiktor Moskwa <wiktorDOTmos..._at_gmail.com> wrote:
> On 10.09.2007, ebwri..._at_gmail.com <ebwri..._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
dbms_system.set_sql_trace_in_session(sid, serial#, TRUE/FALSE) dbms_system.set_ev(sid, serial#, event, level, '')
David Fitzjarrell Received on Mon Sep 10 2007 - 16:19:34 CDT