Re: How to Find Hot Tables?

If you are using 8i, you can alter the table "monitoring". This will tell you how many inserts / updates/ deletes has happened to a particular table. If you don't have that option, you can query the sqlarea to get totals of inserts updates and deletes by table.

In article <39EF8BE3.DE938796_at_fmr.com>,
  Karen <karen.abgarian_at_fmr.com> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 20 2000 - 15:56:11 CDT