Re: (long) Sniffing redo logs to maintain cache consistency?

"Andrej Gabara" <andrej_at_kintana.com> wrote in message news:11a3a163.0303040604.39653a9e_at_posting.google.com...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<3e631f79$0$6294$ed9e5944_at_reading.news.pipex.net>...
> >
> > I very nearly ended up with yet another unusable coffee stained keyboard
> > after this one. The only possible answer is that 300mb is all it needs
(for
> > his load at his site).
>
> Sorry, did not mean to cause any hardware failures. So, before you read
> this, please put the mug down! :)

No worries.

>
> Let's say your server came with 4GB, but Oracle only used up 300MB.
> Would not somebody ask you, the Oracle DBA, to give Oracle more memory?

Being an awkward b***er I'd ask why. If it was 'to tune' the db I'd be asking where it was slow and how they knew that adding ram would help. Or possibly tell them to use sql server that just grabs all available ram regardless. I don't get to talk to external customers much :(.

Seriously reconfiguring Oracle is an important and technical task that should be up to the DBA in charge of the app. The criteria for performance tuning ought to be what response times/throughput you need not how many resources you can consume. In fact once upon a time folk thought that one should try to use as few resources as efficiently as possible, one would have hoped that with the downturn in spending people might realize that this approach is the correct one.

> Maybe, now that memory is cheaper, people could expect the same from an
> app server? I.e. make it possible to tune the app server to make the
> most of resources available.

Making the most of what you have got is fine, using all of what you have got is not necessarily fine. Suppose your server came with 4TB of RAM and 70PB of disk, would your same app function 1000 times as well?

--
Niall Litchfield
Oracle DBA
Audit Commission UK