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

Home -> Community -> Usenet -> c.d.o.server -> Quick questions on direct insert, undo and parallel prosessing

Quick questions on direct insert, undo and parallel prosessing

From: John <jbradshaw777_at_yahoo.com>
Date: 22 Oct 2003 15:32:57 -0700
Message-ID: <f2f59d82.0310221432.50cc341f@posting.google.com> 





Hi groups,



A few quick confirmations of sort...


1. Direct load insert WILL always generate redo IF ORACLE is in
ARCHIVELOG mode.


2. Parallel query processing will not happen (regardless of how your
table, database is set up) unless you you hint it in your queries.
3. Undo tablespace is created more for the purpose of supporting
flash-back query than for the purpose of automating rollback
management. It does not offer any improvemnet on the chance of you
hitting the ORA-01555.



TIA.


John
Received on Wed Oct 22 2003 - 17:32:57 CDT












Original text of this message













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