| indra |
Posted: Nov 23, 2007 07:49:23 AM |
Total Post: 20
Joined: Jan, 2007
|
Friends,
Does increasing the number of redo log files has any impact on Database in any way?
Does it affect the overall performance or recovery performance?
Please help. |
|
|
 sudheer pai |
| Posted: Nov 23, 2007 10:31:07 PM |  |
|
Total Post: 33
Joined: Feb, 2007
|
hi..
more no of redolog files does impact the data base..
performance reduces ... but data is more consistant and it is a compromises on between performance and data intergity
|
|
|
|
|
| indra |
| Posted: Nov 24, 2007 01:33:04 AM | |
|
Total Post: 20
Joined: Jan, 2007
|
How does the performance reduce if the number of redo log file increases?
|
|
|
|
|
| MOH_DBA |
| Posted: Nov 26, 2007 12:49:16 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
Performance decreaces because the database need to write a lot of dirty block to a lot of redo log files and since the hard disk has fix I/O writing per second that makes the database takes to long to write to the redo logs and then write the redo logs to the database files.
|
|
|
|
|
| sudheer pai |
| Posted: Apr 28, 2008 07:01:54 AM | |
|
Total Post: 33
Joined: Feb, 2007
|
if the database is in archivelog mode.. then more redologs .. more the arcn has to write..
and more i/o operations are likely to happen..
again its the design team thats suppose to decide the no of redolog files and how it shud work...
thats why design takes a longest time..
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
