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: Auditing an app's SQL - How?

Re: Auditing an app's SQL - How?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 13 Dec 2004 05:28:58 -0800
Message-ID: <1102944538.814921.293470@c13g2000cwb.googlegroups.com>


Peter Nolan wrote:
> Also, if you ever want to look at a really detailed trace of your
calls
> you can always run an ODBC trace from your ODBC DSN panel...not sure
if
> you know that, lot's of people don't....it is very handy but it is
very
> slow...

It is incredibly slow, and incredibly verbose. Those who bemoan the 'overhead' of timed_statistics=true or sql_trace ought to try it someday :(

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Mon Dec 13 2004 - 07:28:58 CST

Original text of this message

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