Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: LOG FILE SYNC wait event
> > When more memory requered in a particular pool which pool Oracle does
> choose to get the memory from?
> > Is there any priorities associated?
It uses internal algorithms I've never investigated myself; the idea is of course to reduce the one(s) that are "used less", that are less important for the instance performance given your workload.
> > Why should we set the minimum values knowing that Oracle can adjust them
> as and when required?
Just to be able to provide a safety net in case the internal algorithms don't work for your workload. No one is perfect, so that gives you another opportunity to correct any problem that might happen.
-- Alberto Dell'Era "the more you know, the faster you go" -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 05 2007 - 13:50:11 CDT