Re: I want to monitor all sql executed

"RandyTh" <RandyTh_at_oracleforum.com> wrote in message news:loWff.151216$Io.64902_at_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?.
>
>

Yes, if you install the stand-alone Enterprise Manager console. Then open the list of sessions and in the right window, double-click on a session : it will show the SQL statement the session is currently executing. Received on Sun Nov 20 2005 - 07:57:13 CST