Re: DB Buffer Cache Size

Howard J. Rogers wrote:
>

[snip]  

> I simply don't understand the basis of the question. I offer you a bodge-job
> that fixes nothing, but makes things appear OK on the surface for $10,000;
> and a comprehensive, thorough and "correct" fix of the underlying issues
> for $15,000; and the gist of your question implies you'd pick the $10,000
> option?
>

[snip]

> Even the lowest end of town must known that 10K today, plus 10K next year,
> plus 10K the year after is not a 'quick-and-cheap' alternative to paying
> 15K-right-now-and-that's-all.
>
> Regards
> HJR
Depends where you sit in the hierarchy...My experience is:

Consultant: recommends $15k fix
DBA/Developer: prepares case/spec for $15k fix Project Mgr: asks what can be done for only $10k DBA/Developer: presents $10k and $15k option - stresses importance of latter
Project Mgr: presents $10k and $15k option to senior mgt - stresses importance of saving $5k
Senior Mgt: opts for $10k

Its like a place I'm at, where little or no referential integrity exists on one of the sub-systems. We presented a case for fixing the current data and adding RI, to which the response was:

"What percentage data integrity problems do we currently have?"

Hmmmmm....I always thought data integrity was a boolean.

:-)

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------