Redo buffer allocation retries

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_000_01C047F2.82120290

Content-Type: text/plain;

        charset="iso-8859-1"

We have a 2 CPU (933 MHz), machine running Windows NT server. 2G RAM.Somehow I find the performance of the ORACLE 8.1.5 instance on that machine disappointing. So I checked some V$ view. I found the following query
in the documentation :

SQL> l
  1 SELECT NAME,VALUE FROM V$SYSSTAT
  2* WHERE NAME IN ('redo log space requests','redo buffer allocation retries')
SQL> /

NAME                                                                 VALUE
---------------------------------------------------------------- ---------
redo buffer allocation retries                                         349
redo log space requests                                               1028

Both values should be close to zero. I started this instance 10minutes ago. I deleted 250000 rows from several tables. Thats all. I checked some of my other instances and one instance (8.0.5) only has 4 redo log space requests after 6 months. Does anyone know which parameters in the init.ora I need to change.

IJke van Randen

Company	:Alterra Group Software Engineering, Wageningen, the Netherlands
E-mail		: Y.vanRanden_at_alterra.wag-ur.nl
Tel		: 3131747462

 <<Randen, ing. Y. van.vcf>>

------_=_NextPart_000_01C047F2.82120290

Content-Type: application/octet-stream;

        name="Randen, ing. Y. van.vcf"
Content-Disposition: attachment;

        filename="Randen, ing. Y. van.vcf"

BEGIN:VCARD
VERSION:2.1
N:Randen;Yke
FN:Randen, ing. Y. van
ORG:Alterra
TITLE:ing.
TEL;WORK;VOICE:0317-474632

ADR;WORK:;;;Wageningen;;;NL
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Wageningen=0D=0ANL
EMAIL;PREF;INTERNET:Y.vanRanden_at_Alterra.wag-ur.nl