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: <ebwright_at_gmail.com>
Date: Mon, 10 Sep 2007 12:31:34 -0700
Message-ID: <1189452694.392034.65840@57g2000hsv.googlegroups.com>


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.

Eric Received on Mon Sep 10 2007 - 14:31:34 CDT

Original text of this message

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