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: I want to monitor all sql executed

Re: I want to monitor all sql executed

From: RandyTh <RandyTh_at_oracleforum.com>
Date: Sun, 20 Nov 2005 08:23:45 GMT
Message-ID: <loWff.151216$Io.64902@clgrps13>

"Jackson" <Jackson_at_dddd.com> wrote in message news:Rc6ff.202491$ir4.28073_at_edtnps90...
> What is the tool to monitor all sql executed say last a couple of hours?
> I have looked at TopSQL but this doesn't produce what i wanted.
>
> Thanks in advance.
>
>

>Use an after logon trigger (installed with schema SYS) and enable/disable
>this trigger whenever you want to trace sessions. Warning : this could

>Example :

>create or replace trigger trace_sessions
>after logon on database
>begin
> execute immediate 'alter session set sql_trace=true';
>end;
>generate a large amount of trace files !

I know I just want to know the way to monitor only sql. Oracle doesn't provide any option to monitor this in GUI?. Received on Sun Nov 20 2005 - 02:23:45 CST

Original text of this message

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