RE: Auditing, how to capture sql statement issued

I want to capture the sql statements for auditing purposes not for reuse of sql statements.

Thanks
Rick

> -----Original Message-----
> From: Sachin Puri [SMTP:sachin_at_siworldwide.com]
> Sent: Tuesday, January 16, 2001 9:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Auditing, how to capture sql statement issued
>
>
>
> Cale
> I think you mean to reuse the sql statement sometime again.
> if this is the case then u can save the query in the sql*plus editor
> in
> some file location
> or u can just use SAVE <A> after your query in the sql*plus .
> The next time u want to use the query u can just use ' @ A ' .
>
> e.g select * from tab;
>
>
> TNAME TABTYPE CLUSTERID
> ------------------------------ ------- ---------
> AB TABLE
> CD TABLE
> DISTINCT_TEST TABLE
> EMP TABLE
> LXAPPLICATION TABLE
> LXAUCTION TABLE
> LXAUCTIONHISTORY TABLE
> LXAUCTIONSTATUS TABLE
> LXBID TABLE
>
>
> SQL> save a replace
> Wrote file a
>
> SQL> @ a
>
> TNAME TABTYPE CLUSTERID
> ------------------------------ ------- ---------
> AB TABLE
> CD TABLE
> DISTINCT_TEST TABLE
> EMP TABLE
> LXAPPLICATION TABLE
> LXAUCTION TABLE
> LXAUCTIONHISTORY TABLE
> LXAUCTIONSTATUS TABLE
> LXBID TABLE
>
>
> you can also use the sql*plus editor by just typing 'ed' as it will load
> the last executed sql query in
> the editor where you save your query.
>
> Rgds,
> ======
> Sachin Puri
> Oracle Development and Administration
> Solutions NY
> Tel : +91-11-6220102 x 22
> Direct : +919810373243
>
>
>
> -----Original Message-----
> Sent: Tuesday, January 16, 2001 6:31 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi DBAs,
>
> Is there a way to capture the actual sql statement issued while in
> sql*plus,worksheet,etc?
>
> Thanks,
> Rick Cale, Science Applications International Corp.
> Phone:865-481-2198, fax:865-481-8555
> e-mail: caler_at_saic.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sachin Puri
> INET: sachin_at_siworldwide.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Jan 16 2001 - 10:39:05 CST