Re: High elapsed/cpu ratio

On Sep 10, 1: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

Also see Mladen's oradebug article: http://www.mladen-gogala.com/oradebug.pdf

jg

--
@home.com is bogus.
http://www.newsfactor.com/story.xhtml?story_id=55048