| Clearing Redo logs [message #210006] |
Mon, 18 December 2006 22:30  |
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 #210012 is a reply to message #210011] |
Mon, 18 December 2006 22:57  |
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 #210045 is a reply to message #210014] |
Tue, 19 December 2006 01:46 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
