Performance: How many reads of a table

From: Udo Neumann <udp.neumann_at_sw-hb.de>
Date: Thu, 05 Aug 1999 08:48:32 +0200
Message-ID: <37A933BF.587C@sw-hb.de>

Hello

I analyze the Disk-I/O of a production database (Version 7.3.4). I find some hugh tables (indexes) in some tablespaces and know the disk-I/O for each datafile. But I search for a relation between table <-> extend/blocks <-> datafile to coumpute the disk-I/O for the biggest tables in the tablespace.

When I know which extents/blocks are in a datafile and know the related table, it help a many too. The best solution is to get the direct disk-I/O for each table/index.

Thanks

Udo Received on Thu Aug 05 1999 - 01:48:32 CDT