Re: LOG FILE SYNC wait event
- From: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
- To: "DBA Deepak" <oracle.tutorials@xxxxxxxxx>
- Date: Wed, 5 Sep 2007 20:50:11 +0200
> > 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"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
