Home » RDBMS Server » Server Administration » Redo logs
Redo logs [message #161687] Mon, 06 March 2006 14:03 Go to next message
novastar9
Messages: 4
Registered: March 2006
Location: Belgium
Junior Member
Hi,

do you think that these redo log switches are happening too often ? Oracle seems to recommend "no more than once per hour"
How can you judge that ?

Thanks,
Andy

Thread 1 advanced to log sequence 23014
Current log# 1 seq# 23014 mem# 0: D:\ORACLE\ORADATA\AGR\REDO01.LOG
Mon Mar 06 11:00:53 2006
Thread 1 advanced to log sequence 23015
Current log# 2 seq# 23015 mem# 0: D:\ORACLE\ORADATA\AGR\REDO02.LOG
Mon Mar 06 11:44:14 2006
Thread 1 advanced to log sequence 23016
Current log# 3 seq# 23016 mem# 0: D:\ORACLE\ORADATA\AGR\REDO03.LOG
Mon Mar 06 14:15:02 2006
Thread 1 advanced to log sequence 23017
Current log# 1 seq# 23017 mem# 0: D:\ORACLE\ORADATA\AGR\REDO01.LOG
Mon Mar 06 15:21:38 2006
Thread 1 advanced to log sequence 23018
Current log# 2 seq# 23018 mem# 0: D:\ORACLE\ORADATA\AGR\REDO02.LOG
Mon Mar 06 16:32:45 2006
Thread 1 advanced to log sequence 23019
Current log# 3 seq# 23019 mem# 0: D:\ORACLE\ORADATA\AGR\REDO03.LOG
Mon Mar 06 17:06:10 2006
Thread 1 advanced to log sequence 23020
Current log# 1 seq# 23020 mem# 0: D:\ORACLE\ORADATA\AGR\REDO01.LOG
Mon Mar 06 17:34:18 2006
Thread 1 advanced to log sequence 23021
Current log# 2 seq# 23021 mem# 0: D:\ORACLE\ORADATA\AGR\REDO02.LOG
Mon Mar 06 17:58:13 2006
Thread 1 advanced to log sequence 23022
Current log# 3 seq# 23022 mem# 0: D:\ORACLE\ORADATA\AGR\REDO03.LOG

Report message to a moderator

Re: Redo logs [message #161735 is a reply to message #161687] Mon, 06 March 2006 23:11 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Are you facing any problem due to log switches???

Report message to a moderator

Re: Redo logs [message #161773 is a reply to message #161735] Tue, 07 March 2006 02:06 Go to previous messageGo to next message
novastar9
Messages: 4
Registered: March 2006
Location: Belgium
Junior Member
no, there's no problem but just curious. Our other databases have a much less frequent redo switch frequency.

Andy

Report message to a moderator

Re: Redo logs [message #161776 is a reply to message #161687] Tue, 07 March 2006 02:40 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
compare the size of redo logs in differenr databases ,
it might help

Report message to a moderator

Re: Redo logs [message #161797 is a reply to message #161776] Tue, 07 March 2006 04:20 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

It depends on the work load on the database.

May be other databases are not facing that much of DML/DDL activities like this.

Report message to a moderator

Previous Topic: OS authenitication
Next Topic: tns-12535
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:50:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.