The minimum extent lenght is a new tablespace feature
on Oracle 8.x.
It forces the extent size to be a multiple of the
minimum extent lenght parameter.
Let say you create a tablespace
create tablespace tbs datafile....
default storage (initial 100K next 100K pctincrease 0)
minimum extent 100K;
If you create a table like
create table ...
storage (initial 150K...)
Oracle will create it with an initial extent of 200K.
Each extent will be a multiple of the minimum extent
lenght.
- Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com> a
écrit : >
> 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.
> --
> Author: Sandeep Kurliye
> INET: Sandeep.Kurliye_at_almarai.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Wed Aug 09 2000 - 03:10:49 CDT
