Re: Measuring I/O activity on a per-table basis

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/08/13
Message-ID: <33F2764A.4B18@postoffice.worldnet.att.net>#1/1

If you do not have an inordinate number of tables that you want to check, create a new tablespace, move the tables, one at a time, into that tablespace and monitor file I/O on the datafile(s) that make up that tablespace. Move back to its original tablespace the table you just monitored, and proceed with the next one, and so on. Alternatively, if you have enough disk space (and your MAXDATAFILES parameter allows it), put the tables in question each into its own tablespace, and then monitor the corresponding datafiles.

Hope this helps.

Michael Serbanescu

---

Milos Martinovic wrote:
>
> Hi,
>
> I would be glad if I could find the way to evaluate the database
> I/O load on a per-table or per-index basis.
>
> Just to know how many reads/writes occurred against particular tables
> during given period of time.
>
> I am aware that there are many tools available to measure
> file I/O activity but ...
>
> Any ideas ?
>
> TIA
>
> Milos Martinovic
> Oracle DBA
Received on Wed Aug 13 1997 - 00:00:00 CDT