different redo needs same database

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Tue, 6 Apr 2004 10:28:28 +0200
Message-ID: <727A513477946E4380C23DD63C36FCC026BB13@pedro.vrijuit.nl>

Hi,

I'm trying to improve my redo settings because I have logswitches during daytime every
2 to 4 hours and at night during batches every couple of minutes and a few times
within 1 minutes 2 logfile switches. With statspack (interval complete day including night(
I also see

Avg

Total Wait        wait   Waits
Event     Waits   Timeouts   Time (s)   (ms)    /txn


---------------------------- ------------ ---------- ---------- ------

--------

LGWR wait for redo copy    99,642      1,642      68      1     0.1

Details: Oracle 9.2.0.4, HP-UX 11.11,

I have 3 redo loggroups, each 2 members of 150Mb. All files are on a SAN (EVA3000, raid 1)
SQL> show parameter log_check

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

log_checkpoint_interval              integer     5000
log_checkpoint_timeout               integer     60
log_checkpoints_to_alert             boolean     TRUE

SQL> show parameter fast

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
fast_start_parallel_rollback         string      LOW

I am thinking of maybe creating a script that creates small loggroups and delete large groups for use during daytime and creating another script with large loggroups for batch purpose. Any do's and don't advice on these experiences are appreciated.

Tia,

Jeroen

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue Apr 06 2004 - 03:24:25 CDT