Hi
The version is Oracle 8i, so
is there a way to retrieve the sql statement?
could the v$sql view or v$sqltext view be useful?
regards
Arup Nanda <orarup@hotmail.com> wrote:
You haven't specified the Oracle version. If it's 9i, you could use Fine Grained Auditing (FGA) to get the exact SQLs.
Hope this helps.
Arup
----- Original Message -----
Sent: Monday, December 29, 2003 1:39 PM
Subject: Obtain SQL Statement from audit
Hello everybody
I am auditing select statements on one table, so I put the initialization parameter audit_trail = DB and I query the dba_audit_trail and sys.aud$ views and I can get information but I can't get the sql statement.
The question is how can I retrieve the sql statement used to select on my table?
Regards,
Mauricio Vélez
Do you Yahoo!?
Yahoo! Photos - Get your photo on the big screen in Times Square
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vélez"
INET: oraclemavelgo_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Tue Dec 30 2003 - 16:24:32 CST
