Re: log_buffer value does not match spfile value

  • From: "Connor McDonald" <mcdonald.connor@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 8 Jun 2006 22:10:08 +0800

On 6/8/06, Hallas, John, Tech Dev <John.Hallas@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxx web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

Other related posts: