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: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 18 Nov 2005 22:58:01 GMT
Message-ID: <Xns97129859A11F0SunnySD@70.168.83.30>


netcomrade_at_netscape.net wrote in
news:1132350270.419767.96480_at_f14g2000cwb.googlegroups.com:

> Jackson wrote:

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

>
> All sql will be logged on the server in
> $ORACLE_BASE/admin/<SID>/[udump|bdump]
>
>

Are you real sure about your statement?
Even SELECT statements?
I do not think so; unless of course you previously enabled SQL_TRACE at the instance level. Received on Fri Nov 18 2005 - 16:58:01 CST

Original text of this message

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