different redo needs same database
- From: Jeroen van Sluisdam <jeroen.van.sluisdam@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Apr 2004 10:28:28 +0200
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
-----------------------------------------------------------------
Other related posts:
