auditing table help
From: Alessandro Lia <a.lia_at_tct-it.com>
Date: Wed, 2 Mar 2011 10:36:41 +0100
Message-ID: <001001cbd8bd$56238ca0$130210ac_at_CPU002019>
Dear list,
I need to trace which statement run on one table. I just need to know i.e. "select etc...." My DB parameter are set for auditing.
I run the following script :
audit select on "user.table_name" by session;
Date: Wed, 2 Mar 2011 10:36:41 +0100
Message-ID: <001001cbd8bd$56238ca0$130210ac_at_CPU002019>
Dear list,
I need to trace which statement run on one table. I just need to know i.e. "select etc...." My DB parameter are set for auditing.
I run the following script :
audit select on "user.table_name" by session;
If I query the AUD$ table I get:
SESSIONID ENTRYID STATEMENT TIMESTAMP USERID
3355750 1 24 01-MAR-11 XXXXX
but I'm not able to find the statement executed. Is there any way to get it? Is there any V$table to join to retrieve such info?
thank you for your collaboration
Alessandro
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 02 2011 - 03:36:41 CST