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

Actually, UTLBSTAT/UTLESTAT will provide stats for datafiles and tablespaces. I don't think there is a method for identifying a specific number of hits that a specific table is receiving. Your best bet is probably using file and tablespace i/o along with an understanding of the application and the segments that reside in those specific files. Enterprise Manager may have a tool or a 3rd party vendor may have some application that provides this information; however, I have not heard of such a tool.

In article <6t7kaj$b5_at_sjx-ixn10.ix.netcom.com>,   "Winnie Liu" <oracle_dba_at_zdnetmail.com> wrote:
> 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.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 11 1998 - 22:02:13 CDT