 | | | LOG FILE SYNC wait event | LOG FILE SYNC wait event 2007-09-04 - By Rich Jesse
Back
If I'm not mistaken, log_buffer will be automagically sized at instance
startup if using ASMM, effectively ignoring the setting of the log_buffer
parameter. This is eluded to in the paragraph below your reference:
"The memory allocated to these pools [including log_buffer] is deducted from
the total available for SGA_TARGET when Automatic Shared Memory Management
computes the values of the automatically tuned memory pools."
Also see MeatLink 373018.1.
Someone please correct me if I'm wrong. (be gentle!)
Rich
> BTW The log buffer is not managed by the Automatic Shared Memory Management
> in 10gR2:
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams192
.htm
>
> "The following pools are manually sized components and are not
> affected by Automatic Shared Memory Management:
> * Log buffer
--
http://www.freelists.org/webpage/oracle-l
|
|
|