Re: Help: archive log switch too frequent

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 Tue Feb 17 1998 - 00:00:00 CST