Home » SQL & PL/SQL » SQL & PL/SQL » Clearing Redo logs
Clearing Redo logs [message #210006] Mon, 18 December 2006 22:30 Go to next message
Bijupm
Messages: 16
Registered: February 2006
Junior Member
Hai,

I want to clear my redo logs as part of the performance tuning.

But i don't know how to do it.

Can anybody help me...

Regards,
Biju.
Re: Clearing Redo logs [message #210011 is a reply to message #210006] Mon, 18 December 2006 22:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
plz clear your question.
I want to clear my redo logs as part of the performance tuning.

you want to know about redo logs member or group.?
or anything else.


regards
Taj
Re: Clearing Redo logs [message #210012 is a reply to message #210011] Mon, 18 December 2006 22:57 Go to previous messageGo to next message
Bijupm
Messages: 16
Registered: February 2006
Junior Member
Hai Taj,

I am new to this...

As my application takes more time,someone ask me to clear your redo logs to get better performance?

I want to know about both... and steps to clear redo logs.

can u pls help me.

Regards,
Biju.

Re: Clearing Redo logs [message #210013 is a reply to message #210012] Mon, 18 December 2006 23:00 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
it is very hard to say what is going on in your application.
if your application taking more time then generate statpack report or use tkprof and post here and your database version also.


regards
Taj
Re: Clearing Redo logs [message #210014 is a reply to message #210013] Mon, 18 December 2006 23:08 Go to previous messageGo to next message
Bijupm
Messages: 16
Registered: February 2006
Junior Member
Hai,

Anyhow can u pls give the steps to clearing redologs...

Regards,
Biju.
Re: Clearing Redo logs [message #210045 is a reply to message #210014] Tue, 19 December 2006 01:46 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
In my opinion, you have either misunderstood some advice, or you have been advised by someone who doesn't understand what they're talking about.

Redo logs are filled as your application does work. Once a single log is full, it is copied to the archive area, and the log is then available to be reused again.
You can issue the command 'Alter System Switch Logfile' to force this behaviour before a redo log is full, but that will not mystically speed up your system.

If your log files are filling up and switching too frequently, it might be worth making them larger.

It would be worth your while thatking @user52s advice and generating statspack reports for your Db - these will show you the amount of Redo that you generate, and show you a variety of places where tuning might be effective.
Previous Topic: tnsnames.ora and listener.ora
Next Topic: Diff b/w two dates
Goto Forum:
  


Current Time: Sat Dec 10 20:17:24 CST 2016

Total time taken to generate the page: 0.24154 seconds