Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Very frequent log switch

Oracle_24Apr 12 2012 — edited Apr 13 2012
Hi Experts,

There are too many log switch in alert log,almost in few seconds then i have increased redo log size then it is like 2 minutes.

I have checked in JOBS but nothing going on.

TRIDION application via dllhost.exe is just connected no one is working on that.

Please guide me


Thank you,
Himanshu




Please find the below details.


BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production



Redo log group sizing is 200 MB

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 748 209715200 2 NO ACTIVE 941421 12-APR-12
2 1 749 209715200 2 NO CURRENT 942233 12-APR-12
3 1 746 209715200 2 NO ACTIVE 939775 12-APR-12
4 1 747 209715200 2 NO ACTIVE 940452 12-APR-12



Thu Apr 12 09:13:41 2012
Thread 1 advanced to log sequence 725 (LGWR switch)
Current log# 2 seq# 725 mem# 0: /redo/db/cmsprod/redo-03
Current log# 2 seq# 725 mem# 1: /redo/db/cmsprod/redo-04
Thu Apr 12 09:14:05 2012
Thread 1 advanced to log sequence 726 (LGWR switch)
Current log# 3 seq# 726 mem# 0: /redo/db/cmsprod/redo-5
Current log# 3 seq# 726 mem# 1: /redo/db/cmsprod/redo-6
Thu Apr 12 09:14:56 2012
Thread 1 advanced to log sequence 727 (LGWR switch)
Current log# 4 seq# 727 mem# 0: /redo/db/cmsprod/redo-7
Current log# 4 seq# 727 mem# 1: /redo/db/cmsprod/redo-8
Thu Apr 12 09:16:22 2012
Thread 1 advanced to log sequence 728 (LGWR switch)
Current log# 1 seq# 728 mem# 0: /redo/db/cmsprod/redo-01
Current log# 1 seq# 728 mem# 1: /redo/db/cmsprod/redo-02
Thu Apr 12 09:17:49 2012
Thread 1 advanced to log sequence 729 (LGWR switch)
Current log# 2 seq# 729 mem# 0: /redo/db/cmsprod/redo-03
Current log# 2 seq# 729 mem# 1: /redo/db/cmsprod/redo-04
Thu Apr 12 09:18:35 2012
Thread 1 advanced to log sequence 730 (LGWR switch)
Current log# 3 seq# 730 mem# 0: /redo/db/cmsprod/redo-5
Current log# 3 seq# 730 mem# 1: /redo/db/cmsprod/redo-6
Thu Apr 12 09:19:35 2012
Thread 1 advanced to log sequence 731 (LGWR switch)
Current log# 4 seq# 731 mem# 0: /redo/db/cmsprod/redo-7
Current log# 4 seq# 731 mem# 1: /redo/db/cmsprod/redo-8
Thu Apr 12 09:20:32 2012
Thread 1 advanced to log sequence 732 (LGWR switch)
Current log# 1 seq# 732 mem# 0: /redo/db/cmsprod/redo-01
Current log# 1 seq# 732 mem# 1: /redo/db/cmsprod/redo-02
Thu Apr 12 09:22:45 2012
Thread 1 advanced to log sequence 733 (LGWR switch)
Current log# 2 seq# 733 mem# 0: /redo/db/cmsprod/redo-03
Current log# 2 seq# 733 mem# 1: /redo/db/cmsprod/redo-04
Thu Apr 12 09:24:25 2012
Thread 1 advanced to log sequence 734 (LGWR switch)
Current log# 3 seq# 734 mem# 0: /redo/db/cmsprod/redo-5
Current log# 3 seq# 734 mem# 1: /redo/db/cmsprod/redo-6
Thu Apr 12 09:26:02 2012
Thread 1 advanced to log sequence 735 (LGWR switch)
Current log# 4 seq# 735 mem# 0: /redo/db/cmsprod/redo-7
Current log# 4 seq# 735 mem# 1: /redo/db/cmsprod/redo-8
Thu Apr 12 09:27:38 2012
Thread 1 advanced to log sequence 736 (LGWR switch)
Current log# 1 seq# 736 mem# 0: /redo/db/cmsprod/redo-01
Current log# 1 seq# 736 mem# 1: /redo/db/cmsprod/redo-02
Thu Apr 12 09:29:11 2012
Thread 1 advanced to log sequence 737 (LGWR switch)
Current log# 2 seq# 737 mem# 0: /redo/db/cmsprod/redo-03
Current log# 2 seq# 737 mem# 1: /redo/db/cmsprod/redo-04
Thu Apr 12 09:30:12 2012
Thread 1 advanced to log sequence 738 (LGWR switch)
Current log# 3 seq# 738 mem# 0: /redo/db/cmsprod/redo-5
Current log# 3 seq# 738 mem# 1: /redo/db/cmsprod/redo-6
Thu Apr 12 09:31:07 2012
Thread 1 advanced to log sequence 739 (LGWR switch)
Current log# 4 seq# 739 mem# 0: /redo/db/cmsprod/redo-7
Current log# 4 seq# 739 mem# 1: /redo/db/cmsprod/redo-8
Thu Apr 12 09:32:24 2012
Thread 1 advanced to log sequence 740 (LGWR switch)
Current log# 1 seq# 740 mem# 0: /redo/db/cmsprod/redo-01
Current log# 1 seq# 740 mem# 1: /redo/db/cmsprod/redo-02
Thu Apr 12 09:33:32 2012
Thread 1 advanced to log sequence 741 (LGWR switch)
Current log# 2 seq# 741 mem# 0: /redo/db/cmsprod/redo-03
Current log# 2 seq# 741 mem# 1: /redo/db/cmsprod/redo-04
Thu Apr 12 09:34:40 2012
Thread 1 advanced to log sequence 742 (LGWR switch)
Current log# 3 seq# 742 mem# 0: /redo/db/cmsprod/redo-5
Current log# 3 seq# 742 mem# 1: /redo/db/cmsprod/redo-6
Thu Apr 12 09:35:35 2012
Thread 1 advanced to log sequence 743 (LGWR switch)
Current log# 4 seq# 743 mem# 0: /redo/db/cmsprod/redo-7
Current log# 4 seq# 743 mem# 1: /redo/db/cmsprod/redo-8
Thu Apr 12 09:37:21 2012
Thread 1 advanced to log sequence 744 (LGWR switch)
Current log# 1 seq# 744 mem# 0: /redo/db/cmsprod/redo-01
Current log# 1 seq# 744 mem# 1: /redo/db/cmsprod/redo-02
Thu Apr 12 09:39:10 2012
Thread 1 advanced to log sequence 745 (LGWR switch)
Current log# 2 seq# 745 mem# 0: /redo/db/cmsprod/redo-03
Current log# 2 seq# 745 mem# 1: /redo/db/cmsprod/redo-04
Thu Apr 12 09:40:59 2012
Thread 1 advanced to log sequence 746 (LGWR switch)
Current log# 3 seq# 746 mem# 0: /redo/db/cmsprod/redo-5
Current log# 3 seq# 746 mem# 1: /redo/db/cmsprod/redo-6
Thu Apr 12 09:42:35 2012
Thread 1 advanced to log sequence 747 (LGWR switch)
Current log# 4 seq# 747 mem# 0: /redo/db/cmsprod/redo-7
Current log# 4 seq# 747 mem# 1: /redo/db/cmsprod/redo-8

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

Edited by: Oracle_2410 on Apr 12, 2012 1:53 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2012
Added on Apr 12 2012
#general-database-discussions
12 comments
1,637 views