Database Parameters and Redo Log Contention

From: Gary Corless <gary.corless_at_gen.friendsfirst.ie>
Date: Thu, 18 Mar 1999 12:30:16 -0000
Message-ID: <7cqre0$ls5$1@news1.news.iol.ie>

I work in a small IT dept and picked Oracle as the database for our new system. The problem is it's hard to know what sizes things should be (the default sizes seem very small). I've got 53 Redo Log Contentions within the first 2 weeks of the pilot project. The application is not yet critical so db recovery currently set for 3 days.

Question 1 : Are the SGA sizes to big/small?

Question 2 : Would increasing or decreasing the redo log sizes , log_checkpoint_interval or log_checkpoint_timeout reduce the Log Contention?

Spec :
Oracle 7.3.3 (Migrating to 8 at the end of the year), NT(sp3),
Dual P2 450,
512 MB Ram,
8G Data
have ~5000 transactions creating logs at 50M-70M/day (idle for 12 hours) db_block_size = 4096
redo log size = 12,880K (8 groups)
log_checkpoint_interval = 10000
log_checkpoint_timeout = 0

-----------------------SGA-----------------------
Total System Global Area     385,147K
Fixed Size                                         35K
Variable Size                          162,698K
Database Buffers                    216,268K
Redo Buffers                                6,144K

Thanks for the Help,

Gary Received on Thu Mar 18 1999 - 06:30:16 CST