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.

Report message to a moderator

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: 10708
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?

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 05:48:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.