RE: Oracle Book Mal-practice...

  • From: "Matthew Zito" <mzito@xxxxxxxxxxx>
  • To: "Toon Koppelaars" <toon.koppelaars@xxxxxxxxxxx>
  • Date: Fri, 22 May 2009 12:36:14 -0400

*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.





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

(co)Author: "Applied Mathematics for Database Professionals"

Other related posts: