Re: DBA_SEGMENT query question

From: rolf.wild <m103268_at_stix3>
Date: 1997/01/17
Message-ID: <5bnnui$297@newsser1.gmsg.ch>#1/1

The segmenttype cache is used for the so called 'bootstrap segment'. Oracle uses it to store
the datadictionary version.
Its size is only 1 oracle block, probably therefore they set max_extents to zero.

you can't find any description of this special type in the ordinary oracle manuals.

Rolf Wild
DBA in Switzerland

> SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS
> ------------------------- ----------------- ---------- -----------
> 1.377 CACHE 1 0
> Brett Cunningham
> zgeist_at_ee.net
>

--
rolf.wild_at_gmsg.ch

Received on Fri Jan 17 1997 - 00:00:00 CST