Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: insert nologging parallel/noparallel and archiving
Gene,
This sounds right.
Standard insert as append does freelist block checking and generates redo. Parallel DML generates minimial redo, just for the new temp segments being created, not for the datablock updates. This is one reason it is so fast.
Index changes are always logged, even in PDML and append modes.
One way to consider would be to alter indexes to unusable and rebuild with nologging and compute statistics clauses. This way, your load is fast, you generate minimal redo, and your indexes are balanaced and have good stats afterwards.
A space consideration with PDML and dictionary managed tablespaces - each PQ process in your PDML is going to have its own extent. This extent will begin life with a size=initial, but will have the empty space trimmed off at the end of the write, leaving an odd size extent. Since you are doing PDML, you might have these extents close together, and when the trim occurs, it will leave odd sized holes in between and throw off your space managment strategy. I don't believe that LMT tablespaces have this issue.
hth,
jack
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: jack_silvey_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Jul 05 2002 - 14:23:21 CDT