Enable auditing on the table and then you can get details from
dba_aduit_trail table
for Enable auditing you have to set
Audit_Trail=true in your parameter file
where true means DB
if you want to generate OS file then set it to OS instead of true.

May be this will help you

----- Original Message -----
From: "Agus Purwanto "
<oracledba-ezmlmshield-x79054721.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 30, 2005 1:51 AM
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
>
>


Oracle LazyDBA home page