Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: High elapsed/cpu ratio

Re: High elapsed/cpu ratio

From: Wiktor Moskwa <wiktorDOTmoskwa_at_gmail.com>
Date: Mon, 10 Sep 2007 20:14:27 +0000 (UTC)
Message-ID: <fc48j3$nk8$1@nemesis.news.tpi.pl>


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
Received on Mon Sep 10 2007 - 15:14:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US