Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: log_buffer value does not match spfile value
On 6/8/06, Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk> wrote:
>
> I have had a couple of private responses on this as well a couple to the
> list
>
>
>
> Firstly I should have typed ASMM (Automatic Shared memory Mananagment)
> rather than ASSM. I knew what I meant but I bet I am not the first one to
> make that mistake
>
>
>
> Secondly the CPU count is either 2,4, or 8 depending on which server I try
> it on. Not really sure what line is being taken on that one
>
>
>
> Finally I have been informed that the log_buffer shares a memory granule
> with the fixed SGA. That had crossed my mind but I had not been able to
> track any supporting evidence down.
>
The reference says the default is 512k or 128k * cpu_count, but I'm guessing that's out of date. On my laptop, I don't seem to be able to get lower than 2904064.
-- Connor McDonald =========================== email: connor_mcdonald_at_yahoo.com web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 08 2006 - 09:10:08 CDT
![]() |
![]() |