Re: excessive archive log
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 Dec 2007 17:20:15 -0800 (PST)
If you have indexes on the table, any type of DML activity will have redo
generated from the indexes (even if you do direct path load).
It is better to drop indexes (if at all feasible) before doing any bulk direct
path loading.
Thanks,
Sai
http://sai-oracle.blogspot.com
How are you inserting the data? Just because a tablespace is in
NOLOGGING mode doesn't mean INSERTs aren't logged, that only applies
to direct-path/append INSERTs. UPDATEs will always be logged
regardless.
Don.
On Dec 7, 2007 10:22 AM, <ryan_gaffuri@xxxxxxxxxxx> wrote:
> 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?
--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l
Follow-Ups:
RE: excessive archive log
From: Shamsudeen, Riyaj
References:
excessive archive log
From: ryan_gaffuri
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
//www.freelists.org/webpage/oracle-l
Other related posts:
