Re: Table I/O stats possible?

From: Dennis Buddenborg <buddman_at_flash.net>
Date: Fri, 09 Jul 1999 18:27:44 GMT
Message-ID: <37863EF0.B02C960D@flash.net>

Doug,

There is an Oracle supplied script (catio.sql) located in the ?/rdbms/admin directory that creates a stored procedure (sample_io) and a view (io_per_object) that will give you a swag at the number of blocks accessed per database object over a user specified period of time and sampling interval. It basically takes a sampling of the buffer cache to see what objects are present. Again, no specific numbers, just a swag.

Cheers,
Dennis Buddenborg
OCP DBA
Valeo, Inc.

Doug Cowles wrote:

> I know I can look at writes/reads etc, by tablespace, but someone has
> hinted that there is a way to actually determine the amount of activity
> for a specific table. This sounds like bull, but is there any chance?
>
> - Dc.
Received on Fri Jul 09 1999 - 13:27:44 CDT