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 21:29:09 +0000 (UTC)
Message-ID: <fc4cv5$4tc$1@atlantis.news.tpi.pl> 





On 10.09.2007, fitzjarrell_at_cox.net <fitzjarrell_at_cox.net> wrote:


> On Sep 10, 3:14 pm, Wiktor Moskwa <wiktorDOTmos..._at_gmail.com> wrote:

>>

>> I'm not sure how to enable trace in other session in 9.2, maybe

>> others can suggest.

>>

> dbms_system.set_sql_trace_in_session(sid, serial#, TRUE/FALSE)

> dbms_system.set_ev(sid, serial#, event, level, '')

>




Thanks :)


-- 
Wiktor Moskwa


Received on Mon Sep 10 2007 - 16:29:09 CDT












Original text of this message













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