Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback extents
Per the math involved here, the # extents multipled by extent size in
yr case is 500*320K=160Megabytes ...which is wayyy smaller than your
single load of 3-8 Gigabytes !!!
Would be interesting to find if NOLOGGING resolves yr problem.
BTW: thinking about the rollback stuff, basic question, any comments on why would Oracle need rollback ( not REDO) for an INSERT or SELECT ?? Received on Wed Jun 26 2002 - 17:54:16 CDT