Re: How often a table is accessed?

I'd be very interested to know that too ... anything beyond MONITOR TABLE command and short of writing triggers and stuff..

Plus the frequency of access for the indexes ... That to will be very useful ...

Any data dictionary and views for these stats ?

Catcox wrote:
>
> Does anybody know of some nifty query which would return a list of tables and
> the frequency with which they are accessed by users?
>
> If you know that this is not possible, I'd like to know that too.
>
> Thank you,
>
> Catherine Cox
> catcox_at_aol.com

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================