Hi I think you have very very little log_checkpoint_interval=5000 log_checkpoint_timeout Your log block size is 1024 bytes ( try this as sysdba: select max(lebsz) from sys.x$kccle; ) With these values you must have a checkpoint every 5 MB !!! Review your alert.log Another question, Do you have each member of a group placed in separated volumns ? If you have everything into a physical volume, there are no usefull. Greetings. -----Mensaje original----- De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En nombre de Jeroen van Sluisdam Enviado el: martes, 06 de abril de 2004 10:28 Para: 'oracle-l@xxxxxxxxxxxxx' Asunto: different redo needs same database 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------