Re: physical reads and writes

There are usually tools offered by the OS that will allow you to see how many i/o's per second you are doing.

utlbstat/utlestat gives you how much data is written to each file and how many writes over a period of time. But it doesn't give you peak access.

For the information you are looking for, it is really by disk, and not by oracle datafile.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Johnson" <syner_at_pd.jaring.my> wrote in message
news:8fih5k$mdk$1_at_news6.jaring.my...


> Hello DBA,

>

> "Keep the total number of physical reads and writes within the optimal


> limits of your hardware and the operating system." from Oracle press -

> Oracle8 Troubleshooting.

>

> Can anyone explain what is mean by " Optimal limits of your hardware and

> Operating System." How am I going to measure it ??

>

> Regards

>

>

>

>

>

>

>

>

>

>