Home » RDBMS Server » Server Administration » Resizing of Redologs
Resizing of Redologs [message #250633] Tue, 10 July 2007 13:19 Go to next message
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

Re: Resizing of Redologs [message #250637 is a reply to message #250633] Tue, 10 July 2007 13:28 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Determine how often you'd like them to switch & size them accordingly!
Re: Resizing of Redologs [message #250644 is a reply to message #250637] Tue, 10 July 2007 13:39 Go to previous messageGo to next message
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


Re: Resizing of Redologs [message #250645 is a reply to message #250644] Tue, 10 July 2007 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Resizing of Redologs [message #250669 is a reply to message #250645] Tue, 10 July 2007 14:52 Go to previous messageGo to next message
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

Re: Resizing of Redologs [message #250702 is a reply to message #250669] Wed, 11 July 2007 00:19 Go to previous messageGo to next message
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

Re: Resizing of Redologs [message #250708 is a reply to message #250702] Wed, 11 July 2007 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
why 75MB? Question

Regards
Michel
Re: Resizing of Redologs [message #250869 is a reply to message #250708] Wed, 11 July 2007 12:01 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Because he can Wink
Previous Topic: Process associated with Database
Next Topic: load data from excell sheet into oracle table
Goto Forum:
  


Current Time: Sat Dec 03 07:49:40 CST 2016

Total time taken to generate the page: 0.17848 seconds