Re: How SEG$ is updated in DMS

From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
To: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
Date: Tue, 1 Feb 2005 16:22:37 +0000

On Tue, 01 Feb 2005 18:20:21 +0800, Hemant K Chitale
<hkchital@xxxxxxxxxxxxxx> wrote:
> 
> True.  The Temporary Segment has already been created.  Next Extents are being
> allocated. That is why SEG$ is being updated.  My question was about
> why the update to SEG$ has to re-update *EVERY* column in the table.

oops, I didn't really contribute anything there. sorry. If its any
consolation I'd probably write the code the same way - i.e. not bother
to check what has changed and what hasn't - after all as we all know
space management operations are a very rare operation in databases. If
it was written the way the apps I manage are written it would be a
delete and an insert for every column for each row :)

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

References:

Re: How SEG$ is updated in DMS
From: Niall Litchfield

Re: How SEG$ is updated in DMS
From: Hemant K Chitale

Re: How SEG$ is updated in DMS

Other related posts: