Re: archivelog performance issues
- From: Joey D'Antoni <jdanton1@xxxxxxxxx>
- To: jachang@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 7 Jul 2009 09:09:17 -0700 (PDT)
How is your storage arranged? In general, with a database of that size, I can't
imagine a significant performance impact from running in archivelog mode,
unless the storage was horribly misconfigured.
Joseph D'Antoni
Synthes USA
________________________________
From: Julio Aguilar-Chang <jachang@xxxxxxxx>
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, July 7, 2009 12:06:33 PM
Subject: archivelog performance issues
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@xxxxxxxx
(505) 667-1004 - work
(505) 665-3687 - fax
*****************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
