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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redo log switches and waits database freezes

Re: Redo log switches and waits database freezes

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Tue, 21 Nov 2006 15:38:04 -0600
Message-ID: <de807caa0611211338n23d7220cg66b75a4519788796@mail.gmail.com> 





Jack,



The first thing I would consider is disabling the constraints and using the
direct path loader. Then after each load, run SQL statements to create a
report of constraint violations. That might help your log switch problem and
maybe your overall project time.



Dennis Williams


--
http://www.freelists.org/webpage/oracle-l


Received on Tue Nov 21 2006 - 15:38:04 CST












Original text of this message













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