OraFAQ Forum: Server Administration » Resizing of Redologs

Home » RDBMS Server » Server Administration » Resizing of Redologs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Resizing of Redologs [message #250633]

Tue, 10 July 2007 13:19

Koolwant
Messages: 49
Registered: June 2007
Location: new jersey

Member

Hi Experts

I am working on 10.2.0.1.0
Platform :- Red Hat Enterprise Linux ES release 4 (Nahant Update 5)

I have 7 redo logs ,each of size 50m.

The archive logs grow up to 9GB a day .

I am going to resize the size of my redo logs to bigger size .( due to a lot of checkpoints.)

Can somebody suggest me the new size what i can use , for better performance.

Thanks in advance.

Regards

Report message to a moderator

Re: Resizing of Redologs [message #250637 is a reply to message #250633]

Tue, 10 July 2007 13:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Determine how often you'd like them to switch & size them accordingly!

Report message to a moderator

Re: Resizing of Redologs [message #250644 is a reply to message #250637]

Tue, 10 July 2007 13:39

Koolwant
Messages: 49
Registered: June 2007
Location: new jersey

Member

Thanks Anacedent
Here is the result from my alert log file................................................

Tue Jul 10 13:53:37 2007
Thread 1 advanced to log sequence 4987
Current log# 5 seq# 4987 mem# 0: /home/oracle/product/10.2.0/db_1/oradata/VMXLA1/redo05.log
Thread 1 advanced to log sequence 4988
Current log# 6 seq# 4988 mem# 0: /home/oracle/product/10.2.0/db_1/oradata/VMXLA1/redo06.log
Thread 1 advanced to log sequence 4989
Current log# 1 seq# 4989 mem# 0: /home/oracle/product/10.2.0/db_1/oradata/VMXLA1/redo01.log
Thread 1 cannot allocate new log, sequence 4990
Checkpoint not complete
Current log# 1 seq# 4989 mem# 0: /home/oracle/product/10.2.0/db_1/oradata/VMXLA1/redo01.log
Tue Jul 10 13:53:48 2007
Thread 1 advanced to log sequence 4990
Current log# 7 seq# 4990 mem# 0: /home/oracle/product/10.2.0/db_1/oradata/VMXLA1/redo07.log
Thread 1 advanced to log sequence 4991
Current log# 2 seq# 4991 mem# 0: /home/oracle/product/10.2.0/db_1/oradata/VMXLA1/redo02.log
Thread 1 advanced to log sequence 4992
Current log# 3 seq# 4992 mem# 0: /home/oracle/product/10.2.0/db_1/oradata/VMXLA1/redo03.log

Thanks

Report message to a moderator

Re: Resizing of Redologs [message #250645 is a reply to message #250644]

Tue, 10 July 2007 13:42

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check v$log_history to see the frequency and change the size to have a switch about every quarter of an hour.

Regards
Michel

Report message to a moderator

Re: Resizing of Redologs [message #250669 is a reply to message #250645]

Tue, 10 July 2007 14:52

Koolwant
Messages: 49
Registered: June 2007
Location: new jersey

Member

Thanks michel for your help

Yes i did apply the changes and changed the new size of my logfiles to 100m;

Regards

Report message to a moderator

Re: Resizing of Redologs [message #250702 is a reply to message #250669]

Wed, 11 July 2007 00:19

manualph
Messages: 1
Registered: July 2007

Junior Member

Hi Koolwant,
Did the new size(100 mb) improve the performance? I personally would have tried 75 mb first. Can you tell me the new time interval between the log switches using the script below?

select
to_char(first_time,'dd hh24:mi:ss') first_time,
round(24 * 60 * (
lead(first_time,1) over (
order by first_time
) -
first_time
),2) minutes
from
v$log_history v
where
recid >= 3654
order by
recid
;

Manu Alphonse

[Updated on: Wed, 11 July 2007 00:23]

Report message to a moderator