Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> different redo needs same database

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US