RE: Oracle Book Mal-practice...
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_at_rulegen.com]
Sent: Friday, May 22, 2009 12:34 PM
To: Matthew Zito
Cc: Thomas.Mercadante_at_labor.state.ny.us; tomdaytwo_at_gmail.com; Oracle-L Subject: Re: Oracle Book Mal-practice...
On Fri, May 22, 2009 at 6:30 PM, Matthew Zito <mzito_at_gridapp.com> 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_at_RuleGen.com www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.RuleGen.com/pls/apex/f?p=14265:13 -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 22 2009 - 11:36:14 CDT