Change the size of your redo logs. Our redo log files are 50 meg in size
and we still have log switches about every 5 minutes during periods of peak
update activity.
Martin Haltmayer wrote in message <34E96622.1A687003_at_KirchGruppe.de>...
>What does
>
>select * from v$backup;
>
>say? What size is your db block size?
>
>Martin Haltmayer
>
>Bong Khin Fah wrote:
>>
>> 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 Thu Feb 19 1998 - 00:00:00 CST
