RE: DBA_TABLESPACES - MIN_EXTLEN

all the extents will be either MIN_EXTLEN or will be a multiple of this value. if the tablespace is created with a UNIFORM extent size "extent management local uniform size 25M"

then this value will be equal to the UNIFORM size given in the storage clause.

Rahul

> ----------
> From: Daren Jackson[SMTP:daren_at_webdiego.com]
> Sent: Thursday, August 10, 2000 1:48 PM
> To: Sandeep Kurliye; NewOraList; oracledba_at_quickdoc.co.uk
> Subject: Re: DBA_TABLESPACES - MIN_EXTLEN
>
> The MIN_EXTLEN column of dba_tablespaces denotes the minimum SIZE of an
> extent that will be allocated within a specific tablespace. You set this in
> your create tablespace command (MINIMUM EXTENT). It is easy to get this
> confused with the minextents storage parameter, but that deals with the
> minimum NUMBER of extents. This is new for 8.
>
> Hope that helps,
> Daren Jackson
>
> ----- Original Message ---
> From: "Sandeep Kurliye" <Sandeep.Kurliye_at_almarai.com>
> To: "NewOraList" <ORACLE-L_at_fatcity.com>; <oracledba_at_quickdoc.co.uk>
> Sent: Tuesday, August 08, 2000 11:53 PM
> Subject: DBA_TABLESPACES - MIN_EXTLEN
>
>
> >
> > Hi Gurus,
> >
> > Can anyone tell me the significance of Min_Extlen field in
> DBA_TABLESPACES.
> >
> > SQL> ;
> > 1 SELECT tablespace_name, initial_extent, next_extent,
> > 2 max_extents, pct_increase, min_extlen
> > 3* FROM dba_tablespaces
> > ORACLE - SQL> /
> >
> > TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS PCT_INCREASE
> > MIN_EXTLEN
> > ------------------------------ -------------- -----------
> > ---------- ------------ ----------
> >
> > SYSTEM 10240 10240 121
> > 50 0
> > USER_DATA 10240 10240 121
> > 50 0
> > ROLLBACK_DATA 10240 10240 121
> > 50 0
> > TEMPORARY_DATA 10240 10240 121
> > 50 0
> > TS_DATA 10240 10240 121
> > 50 0
> > TS_INDEX 10240 10240 121
> > 50 0
> > TS_TMP 10240 10240 121
> > 50 0
> > TS_RBS 10240 10240 121
> > 50 0
> > 10 rows selected.
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Thu Aug 10 2000 - 03:24:54 CDT