Re: How to Find Hot Tables?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 6 Oct 2000 18:26:04 +0200
Message-ID: <970849689.28683.10.pluto.d4ee154e@news.demon.nl>

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 06 2000 - 11:26:04 CDT