Re: Statspack io per tablespace/datafile

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Wed, 23 Aug 2006 12:05:18 GMT
Message-ID: <2wXGg.16647$rP1.9884@news-server.bigpond.net.au>

"Massa Batheli" <mngong_at_gmail.com> wrote in message news:1156271985.613783.260460_at_74g2000cwt.googlegroups.com...
>I intend to gather reads/writes,total io per tablespace / per datafile
> on oracle 9i.
> Statspack has been run and your help with the appropriate query to
> return
> the needed information will be greatly appreciated
>

Hi Massa

If I understand your question correctly, I think v$filestat, joined with v$datafile and v$tablespace will give you the information you're after.

Cheers

Richard Received on Wed Aug 23 2006 - 07:05:18 CDT