I *think* (depending on version???) that there is a file in
$ORACLE_HOME/rdbms/admin called (i think) cattio.sql Anyway, it's a script
you run to make Oracle track IO on a per table basis.
--
Dave A
"Karen" <karen.abgarian_at_fmr.com> wrote in message
news:39EF8BE3.DE938796_at_fmr.com...
> 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 Fri Oct 20 2000 - 20:55:00 CDT
