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: Jackson <Jackson_at_dddd.com>
Date: Fri, 18 Nov 2005 01:54:01 GMT
Message-ID: <Zuaff.116189$S4.69215@edtnps84>


Can I do this from Enterpise Manager?
After set to init.ora What should i do go to TopSQL or somewhere else?

"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:437cfa6f.105666593_at_localhost...
> On Thu, 17 Nov 2005 21:01:37 GMT, "Jackson" <Jackson_at_dddd.com> wrote:
>
> >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.
> >
> sql_trace=true in init.ora
>
> .......
> We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
> remove NSPAM to email
Received on Thu Nov 17 2005 - 19:54:01 CST

Original text of this message

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