To ensure read consistency.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"nilanjan" <nilanjan_sarkar_at_hotmail.com> wrote in message
news:6c8b1f5.0206261454.760b80a7_at_posting.google.com...
> 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 Thu Jun 27 2002 - 02:57:10 CDT
