Re: question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 13 Sep 2000 18:24:17 +0800
Message-ID: <39BF55D1.2611@yahoo.com>

Francis Wong wrote:
>
> When updating a lot of rows in a big table, will Oracle copied uncommitted
> data into datafiles because there is not enough memory in SGA?

With (any) update the changes are written to the datafile (as good as) instantaneously...This is why a commit is nice and quick and a rollback can take hours...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Wed Sep 13 2000 - 05:24:17 CDT