Re: Statspack io per tablespace/datafile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 Aug 2006 21:02:31 +0200
Message-ID: <93lme2th84vfcir1bvf2o2v8j90cgi48ob@4ax.com>

On 22 Aug 2006 11:39:45 -0700, "Massa Batheli" <mngong_at_gmail.com> wrote:

>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
>
>Thanks
>Massa .

Why don't you use the Oracle provided spreport.sql? Does just want you want it. If you want less, just take out the appropiate section.

spreport.sql (and sprepins.sql) are in $ORACLE_HOME/rdbms/admin.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Aug 22 2006 - 14:02:31 CDT