Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> excessive archive log

excessive archive log

From: <ryan_gaffuri_at_comcast.net>
Date: Fri, 07 Dec 2007 16:22:16 +0000
Message-Id: <120720071622.12439.4759733800031646000030972200762302079D9A00000E09A1020E979D@comcast.net>


We have an ETL database where virtually all activity are on tablespace in nologging mode. 90% of our activity is inserts and 10% is updates of 1 column that is not indexed. We do have indexes on the tables being inserted to. Though not large numbers(2-4 with column length of 1-3). We do not have really wide columns. all of this is in noarchive log tablespaces. We are getting relatively speaking alot of redo. We are getting more redo than we are getting data generated.

one thing we may be seeing is that we are using advanced queueing and it is enqueued and dequeued constantly. Could this be causing our archive problems?

how do we investigate this? can I use logminer to research this?

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 07 2007 - 10:22:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US