Home » RDBMS Server » Performance Tuning » datafile random read average time
datafile random read average time [message #199959] Fri, 27 October 2006 02:42 Go to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi friends,

Our database is on HCL machine with RAID 5 technology.
Sometimes I get datafile random read average time more than 30 ms when I monitored database using spotlight tool.
It was mentioned that datafile random read average time should have less than 30 ms.
Generally this happens when no. of database users increases.
Is hard disk is slow?
Please guide me.



Re: datafile random read average time [message #199987 is a reply to message #199959] Fri, 27 October 2006 05:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
It was mentioned that datafile random read average time should have less than 30 ms.

Where?
Re: datafile random read average time [message #200284 is a reply to message #199987] Mon, 30 October 2006 03:53 Go to previous message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi Mahesh,
Thank 4 for ur reply.
It is mentioned in help topics of spotlight tool which I use to monitor performance of oracle database.

Previous Topic: Copying statistics of one table to another
Next Topic: STATS and Last Analyzed Column
Goto Forum:
  


Current Time: Sun Dec 04 06:41:14 CST 2016

Total time taken to generate the page: 0.10950 seconds