Re: How to associate physical I/O to table?

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/09/09
Message-ID: <6t7kaj$b5@sjx-ixn10.ix.netcom.com>#1/1

If I remember correctly, when you run the utlbstat/utlestat, there is a part where it will tell you the IO for the table

Winnie

schenk_at_nbnet.nb.ca wrote in message <6t4huo$k6i$1_at_tortue.nbnet.nb.ca>...
>I am now getting stats of physical I/O per tablespace in 7.3.3, but I would
>really like to know if somehow it is possible to associate physical I/O
with
>the object that was being read? Specifically I would like to know if I can
>pinpoint which of four or five tables in a tablespace are giving the bulk
>of the buffer gets.
>
>Any hints would be greatly appreciated.
>--
>Paul Schenk schenk_at_nbnet.nb.ca
> Verbing weirds language.
Received on Wed Sep 09 1998 - 00:00:00 CDT