Re: LOG_BUFFER setting question

since redo log requests are an indication of activity that is probably quite normal

then have a look at

• what transactions are causing the redo log space requests is it reasonable ?

if so, is it a meaningful percentage of the waits ?

what's Statspack say ? post the report !! "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:arte04$lmbbd$1_at_ID-152732.news.dfncis.de...
> Hello, I would like to ask on more question:
>
> The 8i online CD says:
> --------------------------
> LOG_BUFFER
> Parameter type: Integer
> Parameter class: Static
> Default value: Operating system specific. Maximum: 500K or 128K *
> CPU_COUNT, whichever is greater
> Range of values: Operating system dependent
> --------------------------
> We have 4CPU, so maximum is 524288 ?
> Does it mean that the actual setting of 2097152 (2M) is a mistake ?
> It was set as we found 'redo log space requests' from a script report,
> and the script suggested to increase log_buffer (from 1M already).
>
> If 128k*CPU count is the maximal value, what can I do to decrease 'redo
log
> space requests' still occurring ?
>
> SQL> select substr(name,1,25) Name,
> 2 substr(value,1,15) "VALUE (Near 0?)"
> 3 from v$sysstat
> 4 where name = 'redo log space requests'
> 5 /
>
> NAME VALUE (Near 0?)
> ------------------------- ---------------
> redo log space requests 2988
>
> This definitely far beyond 0 and also increasing over the last months ...
>
> My system:
> Oracle EE 8.1.7 on AIX 4.3.3 (4 CPU), C/S environment with 200 clients,
but
> only 10 active (avg) at the same time.
> Oracle Forms&Reports Runtime Environment on clients.
>
> ThanX in advance,
> Jan
>
>
>
>
>
Received on Mon Nov 25 2002 - 10:44:25 CST