Re: How to capture SQL

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 19 Aug 2004 01:08:03 GMT
Message-ID: <Xns9549B87944CD8SunnySD@68.6.19.6>

Mark Bole <makbo_at_pacbell.net> wrote in
news:bnSUc.4549$QJ3.3033_at_newssvr21.news.prodigy.com:

> Daniel Morgan wrote:

>> Randy Harris wrote:
>> 
>>> Is there a simple means of capturing an SQL statement sent from an
>>> application to an Oracle 9i server (on the server end)?  I've been 
>>> looking
>>> through the documentation, not sure if this should be done with
>>> trace, or auditing or if there is some way to enable SQL logging, or
>>> dump the redo log
>>> or something else.
>> 
>> 
>> Look at the DBMS_SUPPORT built-in package.
>> http://www.psoug.org/reference/dbms_support.html
>> 

>
> Regarding your question "dump the redo log": Yes. DBMS_LOGMNR.
>
> The represented SQL might not exactly match what was submitted, but it
> captures the equivalent logical change record(s). It can be slow and
> require some manual analysis. As Ana mentioned, it's not simple.
>
> What is your need? Auditing? Tuning? Training?
>
> --Mark B.
>

SELECT statements do not end up in redo logfiles. Received on Wed Aug 18 2004 - 20:08:03 CDT