| optimal size of archive log file in Oracle 9i? [message #63885] |
Sun, 21 November 2004 00:01  |
dr alex
Messages: 18
Registered: June 2004
|
Junior Member |
|
|
Hi,
I have an accounting package in Oracle 9i. The system is running in No Archive Mode. But now I need to run the database in Archive mode.
The size of Redo log file is 100M (default size), no. of redo log files is 3.
I want the size of the archive log files not 100M but less, lets say 5M or 10M. I can do so by recreating the control files.
I just want to know :what would be the optimal size of Redo Log Files (5M,10M, 20M,...). If size is 5M, archiver will frequently write the logs and if size is more (say 100M) archiver will not write frequently but while writing it takes long time.
I hope some one has solution.
Thanx in advance.
Yours,
Anup(Nepal)
|
|
|
|
| Re: optimal size of archive log file in Oracle 9i? [message #63898 is a reply to message #63885] |
Mon, 22 November 2004 04:32  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
No need to re-create control files to change redo log file size. You only need to add more members or redo group with desired zsize, then drop old redolog members or groups.
Size depends on the application. And depends also on hardware, maybe you don't even notice the performance drop if you resize your redo to 5mb.....
you can do some tests....
Best luck.
Looking for remote job.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
