Help: archive log switch too frequent

Hi

We have a situation where archive log switch too frequent, at high access time it switches many times within a minute.

Below are some parameters of the system:-

SGA
DB Buffers 19,200K
Fixed Size 39K
Redo Buffers 160K
Variable Size 8,710K

Init Parameters

log_archive_buffer_size 64
log_archibe_buffers 4
log_buffer 163840
log_checkpoint_interval 10000
log_checkpoint_timeout 0
log_checkpoint_to_alert False
log_files 255
log_simultaneous_copies 4
log_small_entry_max_size 80

Rollback Segment
Seg.	Extents	Max	Size(K)
R01	41	121	21,320
R02	121	121	69,920
R03	31	121	31,930
R04	121	121	69920
system	4	121	200

Redo Logs
Member		Group	Size(k)
redo01.log	1	1024
redo02.log	2	1024
redo03.log	3	1024

Our system is a typical OLTP application, with around 70+ session running at once.

Some complex query statements are very slow (=hang).

Can any one help to point out what need to be done on this system?

regards,

Bong Khin Fah
Sarawak Information Systems Sdn. Bhd. Received on Tue Feb 17 1998 - 00:00:00 CST