Re: How often a table is accessed?

Anything like a querry for a cummulative data rather than a current one , Not time based sampling ?????

I believe we were looking for some info like This table has been accessed n times since the database has been started ...
This index has been used n time since the databse has been started ...

Monitor table will give you only the current statistic, of all the currently accessed tables not the cummulative one , nor those tables that has been accessed 4 hours ago but were not being used currently .

Anybody has any other ideas ?

Paul Osborn wrote:
>
> 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
>
> Found another one:
>
> 74.Users Active Report
>
> select username name,
> osuser,
> sql_text Sql,
> disk_reads Reads,
> buffer_gets Gets,
> sorts Sorts
> from v$session s, v$sqlarea a
> where s.sql_address = a.address
> and s.sql_hash_value = a.hash_value
> and status = 'ACTIVE'
> and type != 'BACKGROUND'
>
> Returns various information regarding active sessions (users).
> name - Oracle username.
> osuser - Operating system client user name.
> Sql - Sql statement currently being executed.
> Reads - Number of disk blocks read by this cursor and all cursors caused to
> be executed by this cursor.
> Gets - Number of buffers gotten (in any mode) by this cursor and all cursors
> caused to be executed by this cursor.
> Sorts - Number of sorts performed by the SQL statement.
>
> Regards,
> Paul
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Attachment 2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Paul Osborn

-- 
================================================================
============================
| 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.                            
|
================================================================
============================