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

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

BMC has a product called DB Log Master for Oracle that can analyze the redo logs (and their archived ancestors) and tell you the inserts, updates and deletes per table per time interval. Since selects are not logged, it cannot tell anything about those.

Another source, more fleeting, is the v$sqlarea. You can see the table(s) affected in the SQL_TEXT and the DISK_READS shows the blocks read by the cursor (and any recursive SQL).

-- 
John P. Higgins      Voice:    (309)765-7868
Deere & Company      Fax:      (309)765-7800
John Deere Road      Internet: jh33378nospam_at_deere.com
Moline, IL 61265     Opinions: My Own