| Bishal |
Posted: May 07, 2008 07:58:13 AM |
Total Post: 98
Joined: Apr, 2008
|
Hi guys,
I want to calculate the performance,memory,cpu overhead when th e database is in archive log mode comparing it with database in no archive log mode using performance manager... Can anyone guide me on doing that?
Thanx in advance |
|
|
 Murtuja |
| Posted: May 07, 2008 08:31:51 AM |  |
|
Total Post: 588
Joined: Jan, 2006
|
Hi,
Database in archive log mode is not overhead but it's necessity.You can't expect any Production database with archive log mode.
|
|
|
|
|
| Mohammed Taj |
| Posted: May 07, 2008 09:28:27 AM | |
|
Total Post: 634
Joined: Jul, 2007
|
As above said.
there no overhead with archivelog mode but if you running production database in no archivelog mode then you will lost someday most of your important data.
|
|
|
|
|
| http://sharear.blogspot.com |
| Posted: May 07, 2008 11:44:16 PM | |
|
Total Post: 48
Joined: Apr, 2008
|
Oracle redo logs are archived when you turn-on archivelog mode, and the overhead relates to the work done by the LGWR and ARCH background processes as they write the redo information.
please go through this http://www.dba-oracle.com/t_redo_log_tuning.htm
|
|
|
|
|
| http://sharear.blogspot.com |
| Posted: May 07, 2008 11:46:15 PM | |
|
Total Post: 48
Joined: Apr, 2008
|
if you still interested then go through this :
http://sharear.blogspot.cohttp://sharear.blogspot.com/2008/04/enabling-archivelog-mode.htmlm/2008/04/enabling-archivelog-mode.html
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
