Re: Statspack io per tablespace/datafile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Aug 2006 14:36:31 +0200
Message-ID: <ou6re2hu6g5j8p3fgrb4bo7n0f7jesn4dn@4ax.com>

On 23 Aug 2006 04:13:14 -0700, "Massa Batheli" <mngong_at_gmail.com> wrote:

>Thanks for your time sybrand.I did look into spreport and it has all
>this information that is not needed for the time being it would take a
>lot of time sorting through and cutting and pasting the tablespace name
>and the total io in my workseet and I felt there might be an easier way
>to do this reason for the question.All I want to see is
>tablespace name reads writes
>users 1000 20000
>.....
>.....
>and eventually
>datafile
>users.mdf 23232 34343
>Might be obvious to some one who has done that but it is not to me at
>least for now

search for
Tablespace IO summary statistics
in sprepins.sql

:bid = variable for beginning snapshot id
:eid ditto for end  snapshot id
:dbid = database id from stats$database_instance or v$database
:instance_num = instance_num from stats$database_instance or v$instance
:ela is derived from 

round(((e.snap_time - b.snap_time) * 1440 * 60), 0)

(this is also in sprepins.sql)

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Aug 24 2006 - 07:36:31 CDT