Re: How to monitor database I/O among datafiles ?

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Fri, 7 Jan 2000 18:40:26 -0000
Message-ID: <947270614.9923.0.nnrp-14.c2de6f3d@news.demon.co.uk>

Qlos,

in the $ORACLE_HOME/rdbms/admin directory there are two scripts : utlbstat.sql and utlestat.sql.
Run the first at the point in time when you want to start monitoring, run the second when you want the monitoring process to end. This will produce a report (report.txt) that will, amongst other things, give details of file I-O.

hth

Neil.

qlos_at_my-deja.com wrote in message <8557nj$mf$1_at_nnrp1.deja.com>...
>Hi,
>
>I have to improve performance of my database and I would like to start
>with modification of phisical layout. Then I would need information
>what is current I/O among datafiles ? Is this possible to see this ?
>
>many thanks,
>Qlos
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jan 07 2000 - 12:40:26 CST