archivelog performance issues
From: Julio Aguilar-Chang <jachang_at_lanl.gov>
Date: Tue, 07 Jul 2009 10:06:33 -0600
Message-ID: <4A537289.2090102_at_lanl.gov>
Hello:
What are the performance issues I should be aware of if I decide to enable archivelog mode on an OLTP database? I just inherited this database (about 40GB in size, ~200 users, ~2000 transactions per day), it is not in archivelog mode, and the manager who owns it (not well versed in Oracle) tells me that the previous DBA who just left did not enable archiving for database performance reasons. The Oracle server is an HP DL385, dual core, with 16GB of memory.
Date: Tue, 07 Jul 2009 10:06:33 -0600
Message-ID: <4A537289.2090102_at_lanl.gov>
Hello:
What are the performance issues I should be aware of if I decide to enable archivelog mode on an OLTP database? I just inherited this database (about 40GB in size, ~200 users, ~2000 transactions per day), it is not in archivelog mode, and the manager who owns it (not well versed in Oracle) tells me that the previous DBA who just left did not enable archiving for database performance reasons. The Oracle server is an HP DL385, dual core, with 16GB of memory.
Is there a good reason based on performance for not enabling archivelog mode?
-- ***************************************** Julio Aguilar-Chang Geophysics Group, EES-17 Los Alamos National Laboratory jachang_at_lanl.govReceived on Tue Jul 07 2009 - 11:06:33 CDT
(505) 667-1004 - work
(505) 665-3687 - fax
***************************************** -- http://www.freelists.org/webpage/oracle-l