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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
