Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to Find Hot Tables?

How to Find Hot Tables?

From: <mkb125_at_my-deja.com>
Date: Fri, 06 Oct 2000 13:56:54 GMT
Message-ID: <8rkln2$7rs$1@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 - 08:56:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US