Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> DBA_TABLESPACES - MIN_EXTLEN

DBA_TABLESPACES - MIN_EXTLEN

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Wed, 9 Aug 2000 09:53:14 +0300
Message-Id: <10583.114149@fatcity.com>


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                                       
Received on Wed Aug 09 2000 - 01:53:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US