Hi What is value for parameter audit_trail? Check with audit_trail='db,extended'. Best regards, Pavel. 2011/3/2 Sreejith S Nair <Sreejith.Sreekantan@xxxxxxxxxx> > You can check FGA which is pretty simple to configure and efficient. > > > > Cheers > Sreejith Nair > > > > > From: "Alessandro Lia" <a.lia@xxxxxxxxxx> > To: <Oracle-L@xxxxxxxxxxxxx> > Date: 03/02/2011 03:04 PM > Subject: auditing table help > Sent by: oracle-l-bounce@xxxxxxxxxxxxx > ------------------------------ > > > > 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 > > > > > > > DISCLAIMER: > > "The information in this e-mail and any attachment is intended only for the > person to whom it is addressed and may contain confidential and/or > privileged material. If you have received this e-mail in error, kindly > contact the sender and destroy all copies of the original communication. IBS > makes no warranty, express or implied, nor guarantees the accuracy, adequacy > or completeness of the information contained in this email or any attachment > and is not liable for any errors, defects, omissions, viruses or for > resultant loss or damage, if any, direct or indirect." > > > > >