RE: Oracle Book Mal-practice...

*Maybe* - I still see a lot of boxes with OLTP workloads and big SGAs,
that still require pretty high throughput to disk.  Obviously, YMMV.

 

And buffer cache only helps you for reads, of course, so there's still
folks who want to optimize their storage to make sure data can be
written quickly.

 

Matt

 

________________________________

From: Toon Koppelaars [mailto:toon.koppelaars@xxxxxxxxxxx] 
Sent: Friday, May 22, 2009 12:34 PM
To: Matthew Zito
Cc: Thomas.Mercadante@xxxxxxxxxxxxxxxxx; tomdaytwo@xxxxxxxxx; Oracle-L
Subject: Re: Oracle Book Mal-practice...

 

 

On Fri, May 22, 2009 at 6:30 PM, Matthew Zito <mzito@xxxxxxxxxxx> wrote:

All that being said, there's so many layers of abstraction today
already, and more on the way, that trying to optimize like that is
futile, and almost certainly not worth it.


Even more so, if you take into consideration that today's SGA's (the
buffer cache part of it) can be sized such that most block requests will
be LIO's anyway (instead of PIO's).


-- 
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13

Other related posts: