Re: How SEG$ is updated in DMS

On Tue, 01 Feb 2005 11:12:22 +0800, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
> While running a large CREATE INDEX using a Tablespace Temporary which is
> Dictionary Managed,

<snip sql>
> At this stage, it is still creating the Temporary Segment. Why does it have
> to update ALL the columns of SEG$
> for each Extent being allocated ? No wonder that DMS Temporary Tablespaces
> are called "slow".

I don't believe that it is *creating* the temporary segment, I believe that it is *allocating* extents for use during the sort. (it could of course be allocating extents to the index itself - one would need to see the values of the binds).

That is my understanding of the *temp* usage during this operation is

1. create temp segment (at min size)
2. use temp segment as required to sort data - this may involve new extent creation/allocation
3. mark extents reusable after use.

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