Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: log_buffer value does not match spfile value

Re: log_buffer value does not match spfile value

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Thu, 8 Jun 2006 22:10:08 +0800
Message-ID: <5e3048620606080710s25abe538lfdb2c75b3e7c245f@mail.gmail.com>


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-l
Received on Thu Jun 08 2006 - 09:10:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US