RE: Is my Oracle Server issuing more IO than it can handle

Power failure is not the only thing can affect disk caches and yes my previous 
company had it happen during a patch on the array gone bad.

I agree you're numbers are good but I have had it the other way around.... now 
I do admin maybe because not everyone was on the same page in configuring it 
because it was a shared resource with different demands on the array.

Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106



________________________________
From: Harel Safra [mailto:harel.safra@xxxxxxxxx]
Sent: Wednesday, December 08, 2010 11:42 AM
To: Amaral, Rui
Cc: 'Oracle Dba Wannabe'; niall.litchfield@xxxxxxxxx; okh@xxxxxxxxxxxxx; 
oracle-l@xxxxxxxxxxxxx
Subject: Re: Is my Oracle Server issuing more IO than it can handle

On 08/12/2010 17:13, Amaral, Rui wrote:

Yes in theory that can be true but it depends on several factors:



Why in theory? Please have a look at a snapshot of statistics from one node of 
our data warehouse cluster running on EMC DMX4 storage:
AVG_WRITE_TIME  TOTAL_WRITES    AVG_READ_TIME   TOTAL_READS
1.1     40460   26.78   35864

Much better write times than read times (the high read time is also contributed 
from the large IO the database tends to do).


1) assuming write-back caches on the array have not been disabled (which in my 
opinion they should be)


Why do you think write back cache should be disabled? Proper storage systems 
have sufficient battery backups built in to flush the whole cache to disk in 
case of power failure.

Harel Safra

NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, please go to www.td.com/legal 
for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. 
Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière 
d'aller au www.td.com/francais/avis_juridique pour des instructions.

Other related posts: