auditing table help
From: Alessandro Lia <a.lia_at_tct-it.com>
Date: Tue, 1 Mar 2011 15:11:49 +0100
Message-ID: <000c01cbd81a$9b36cbc0$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: Tue, 1 Mar 2011 15:11:49 +0100
Message-ID: <000c01cbd81a$9b36cbc0$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 Tue Mar 01 2011 - 08:11:49 CST