Re: Gather IO stats

On 30 Jul 2006 06:44:20 -0700, "Charles Hooper" <hooperc2000_at_yahoo.com> wrote:

>If you can find a way to execute the above once every 30 minutes, and
>insert the results into a log table (prefix the first run of the SQL
>statement with CREATE TABLE FILE_ACTIVITY AS, and all subsequent runs
>with INSERT INTO FILE_ACTIVITY), you will be able to monitor the
>activity of read/write activity of the various files - simply subtract
>the PHYRDS, PHYWRTS, PHYBLKRD, PHYBLKWRT, READTIM, WRITETIM of a
>previous run from the values of a more recent run (this can be done
>using a simple SQL statement). The TIMESTAMP column will help
>determine the average activity over the selected time period. The
>above will work for data, indexes, and temp/sort. You can do something
>similar with V$ROLLSTAT and the various other performance views.

And so you will just re-invent statspack!!

--
Sybrand Bakker, Senior Oracle DBA