LOG_BUFFER and ENQUEUE_RESORCES size

From: <alan_at_prsc.qld.gov.au>
Date: Mon, 06 Sep 1999 22:38:51 GMT
Message-ID: <7r1fpr$bqc$1@nnrp1.deja.com>

I have been running David Sisk's checktuning.sql script for the last week and it always reports that tuning is required for Redo Log space requests and Enqueue Waits. From the sample output below can anybody suggest what values I should use?

Current Date and Time: 09/06/1999 21:00:02 Database name: ORA1
Measurement Goal Value Action

------------------------------ ------ -----------
-------------------------------------------------
Library cache hit percent      >=0.99	     1.00 OK
Dictionary cache hit percent   >=0.90	     1.00 OK
Buffer cache hit percent       >=0.90	     0.97 OK
Sort area hit percent	       >=0.90	     0.99 OK
Redo Log space requests        =0	       44 Increase the

LOG_BUFFER in
INIT.ORA

"						  Examine Redo Log size
"						  Examine number of

Redo Log
groups
-- Current value: log_buffer = 327680

• Current value: redo log size = 5242880
• Current value: # of redo log groups = 6 Enqueue waits =0 5 Increase the ENQUEUE_RESOURCES in INIT.ORA
• Current value: enqueue_resources = 400 Checkpoints not completed <=1 0 OK Rollback contention ratio <=0.01 0.00 OK Redo allocation latch miss (W) <=0.01 0.00 OK Redo allocation latch miss (I) <=0.01 0.00 OK Redo copy latch miss (WTW) <=0.01 0.00 OK Redo copy latch miss (Immed) <=0.01 0.00 OK Freelist contention ratio <=0.01 0.00 OK

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 06 1999 - 17:38:51 CDT