High Redo Copy Contention

From: Anurag Minocha <AMinocha_at_herold.com>
Date: Tue, 3 Apr 2001 15:05:47 +0000 (UTC)
Message-ID: <EBBA6D3A81229C42981E3AEA79BF5A4E11125B@jshemail.herold.com>

Hi,

I am getting a High redo copy contention even after increasing the log_small_entry_max_size from 80 to 200. In fact I had a average redo size of 253 before increasing the log_small_entry_max_size parameter. yesterday after running the utlbstat/utlestat files I noticed that my average redo size (redo size/redo entries) has increased to 972.Why has this increased and how do I reduce the redo copy contention.

PLEASE HELP. ON 03/27/2001

---

  Tablespace Miss Ratio
--------------- ----------

redo allocation .095841187
redo copy 95.2702703
redo writing .048722391
row cache objec .000724082

Initialization Parameters

---

log_archive_buffer_size        127
log_archive_buffers            4  
log_archive_min_succeed_dest   1         
log_archive_start              FALSE     
log_block_checksum             FALSE     
log_buffer                     102400    
log_checkpoint_interval        8000      
log_checkpoint_timeout         0         
log_checkpoints_to_alert       FALSE     
log_file_name_convert
log_files                      255 
log_simultaneous_copies        4   
log_small_entry_max_size       80  

ON 04/03/2001

---

  Tablespace Miss Ratio
--------------- ----------

redo allocation .093745374

redo copy 98.1246308

redo writing .019016566

row cache objec .002990484

Initialization Parameters

---

log_archive_buffer_size        127
log_archive_buffers            4  
log_archive_min_succeed_dest   1 
log_archive_start              FALSE 
log_block_checksum             FALSE 
log_buffer                     102400 
log_checkpoint_interval        8000   
log_checkpoint_timeout         0      
log_checkpoints_to_alert       FALSE  
log_file_name_convert                 
log_files                      255    
log_simultaneous_copies        4      
log_small_entry_max_size       200

Thanks
Anurag

-- 
Posted from jshemail.herold.com [63.105.8.12] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Tue Apr 03 2001 - 10:05:47 CDT