|
-
Hi Padmam,
Thank you very much for your input. Here are some more details for your reference.
My system is running OLTP applications. More inserts and updates. Details are following :
My One week Log switches :
Date #Arch Files Size Mb
--------------- ----------- -----------
04-DEC-2001 21 105
05-DEC-2001 50 250
06-DEC-2001 39 195
07-DEC-2001 67 335
10-DEC-2001 18 90
11-DEC-2001 124 620
----------- -----------
319 1595
Log switch details from alert log :
Tue Dec 11 10:01:58 2001
Thread 1 advanced to log sequence 311849
Current log# 3 seq# 311849 mem#0: /u01/u03/oradata/massbej2log5massbej2.dbf
Current log# 3 seq# 311849 mem#1: /u01/app/oracle/product/8.1.6/dbs/log6massbej2.dbf
Tue Dec 11 10:02:56 2001
Thread 1 advanced to log sequence 311850
Current log# 4 seq# 311850 mem#0: /u01/u04/oradata/massbej2log2massbej2.dbf
Current log# 4 seq# 311850 mem#1: /u01/u04/oradata/massbej2masslog2massbej2.dbf
Tue Dec 11 10:04:23 2001
Thread 1 advanced to log sequence 311851
Current log# 5 seq# 311851 mem#0: /u01/u05/oradata/log7massbej2.dbf
Current log# 5 seq# 311851 mem#1: /u01/app/oracle/product/8.1.6/dbs/log8massbej2.dbf
Tue Dec 11 10:05:21 2001
Thread 1 advanced to log sequence 311852
Current log# 3 seq# 311852 mem#0: /u01/u03/oradata/massbej2log5massbej2.dbf
Current log# 3 seq# 311852 mem#1: /u01/app/oracle/product/8.1.6/dbs/log6massbej2.dbf
Tue Dec 11 10:06:22 2001
Thread 1 advanced to log sequence 311853
Current log# 4 seq# 311853 mem#0: /u01/u04/oradata/massbej2log2massbej2.dbf
Current log# 4 seq# 311853 mem#1: /u01/u04/oradata/massbej2masslog2massbej2.dbf
Tue Dec 11 10:07:27 2001
Thread 1 advanced to log sequence 311854
Current log# 5 seq# 311854 mem#0: /u01/u05/oradata/log7massbej2.dbf
Now, with the above details, can you focus some light, to determine the size of the redo log file, so that my log switchs occur every 30 mins.
Thanks in Advance
Regards
Nagesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|