Re: How often a table is accessed?

John P. Higgins wrote:
>
> Joseph Sumalbag wrote:
> >
> > 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 ...
> -------------snip----------
>
> The V$SQLAREA view contains this for tables. It has a row for every
> cursor opened in the database. (Note: if the shared pool is to small, a
> LRU algorithm overwrites old entries.) You would have to parse the SQL
> statement to determine which table(s) the statement uses. You could sum
> all the uses of a table by command_type.
>
> I didn't say this is easy!

I'm very much familiar with V$SQLAREA ... It contains cursors that is CURRENT and active...... NOT CUMMULATIVE .....

Again ... this doesn't contain the info that is wanted .... Please read the INFO that the original poster wanted .

And thanks for the reply .

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