You can use audit on DML only.
In 10G you can audit on select too

-----Original Message-----
From: Agus Purwanto
[mailto:oracledba-ezmlmshield-x79054721.[Email address protected]
Sent: Wednesday, March 30, 2005 11:51 AM
To: LazyDBA Discussion
Subject: SQL Trace for the table ?

Hi,

I have table XYZ, and I want to know how many time that table is
accessed.


thanks
ags


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html





---------------------------------------------------------------------------------------------------------------

orange mail - Connect to your e-mail anywhere with any handset
http://www.orange.co.il/web/corporate/app/omailadviser/webform1.aspx

---------------------------------------------------------------------------------------------------------------
This message contains information that may be confidential or privileged.
If you are not the intended recipient, you may not use, copy or disclose
to anyone any of the information in this message. If you have received
this message and are not the intended recipient, kindly notify the sender
and delete this message from your computer.


Oracle LazyDBA home page