Re: How to Find Hot Tables?

Right - v$access shows the objects currently accessed. You will only catch hot tables if they are accessed by long-running operations. If you want to catch fast hits, I cannot think of anything except for audit for all tablespace (datafile) tables.

Karen

Sybrand Bakker wrote:

> Sure
> V$access has a listed of objects currently accessed. For every object
> (except of course for pl/sql) a tablespace is being maintained, so just join
> dba_tablespaces with dba_segments and v$access and that should provide
> results.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <mkb125_at_my-deja.com> wrote in message news:8rkln2$7rs$1_at_nnrp1.deja.com...
> > Is there a way to identify hot tables in a tablespace. I know that we
> > can identify hot tablespaces and then drill down to the datafile level,
> > mount point, LUN...and so on. But once you've identified the
> > tablespace, can you get anymore granularity i.e. down to the object
> > level?
> >
> > Any ideas?
> >
> > Thanks
> >
> > mkb
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Thu Oct 19 2000 - 19:03:47 CDT