Re: Redo buffer allocation retries

From: <nlzanen1_at_ey.nl>
Date: Mon, 6 Nov 2000 15:47:00 +0100
Message-Id: <10672.121207@fatcity.com>

--0__=4125698F00510FBE8f9e8a93df938690918c4125698F00510FBE Content-type: text/plain; charset=us-ascii

Log_buffer (of the top of my head should take care of the first one, hell it's software maybe the secdond one as well) It's in bytes so increasing it won't hurt your memory consumption.

jack

"Randen, ing. Y. van" <Y.vanRanden_at_Alterra.wag-ur.nl>@fatcity.com on 06-11-2000 14:15:47

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Redo buffer allocation retries

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>>

(See attached file: Randen, ing. Y. van.vcf)

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

--0__=4125698F00510FBE8f9e8a93df938690918c4125698F00510FBE Content-type: application/octet-stream;

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

QkVHSU46VkNBUkQNClZFUlNJT046Mi4xDQpOOlJhbmRlbjtZa2UNCkZOOlJhbmRlbiwgaW5nLiBZ LiB2YW4NCk9SRzpBbHRlcnJhDQpUSVRMRTppbmcuDQpURUw7V09SSztWT0lDRTowMzE3LTQ3NDYz Mg0KQURSO1dPUks6Ozs7V2FnZW5pbmdlbjs7O05MDQpMQUJFTDtXT1JLO0VOQ09ESU5HPVFVT1RF RC1QUklOVEFCTEU6V2FnZW5pbmdlbj0wRD0wQU5MDQpFTUFJTDtQUkVGO0lOVEVSTkVUOlkudmFu UmFuZGVuQEFsdGVycmEud2FnLXVyLm5sDQpSRVY6MjAwMDEwMTFUMTIyNDI1Wg0KRU5EOlZDQVJE Received on Mon Nov 06 2000 - 08:47:00 CST