Re: I want to monitor all sql executed

"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