Tablespace info .. ....
set head off verify off echo off pages 1500 linesize 110 feedback off
alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
select
'TABLESPACE_NAME......................................: '||TABLESPACE_NAME ,
'BLOCK_SIZE...........................................: '||BLOCK_SIZE ,
'INITIAL_EXTENT.......................................: '||INITIAL_EXTENT ,
'NEXT_EXTENT..........................................: '||NEXT_EXTENT ,
'MIN_EXTENTS..........................................: '||MIN_EXTENTS ,
'MAX_EXTENTS..........................................: '||MAX_EXTENTS ,
'MAX_SIZE.............................................: '||MAX_SIZE ,
'PCT_INCREASE.........................................: '||PCT_INCREASE ,
'MIN_EXTLEN...........................................: '||MIN_EXTLEN ,
'STATUS...............................................: '||STATUS ,
'CONTENTS.............................................: '||CONTENTS ,
'LOGGING..............................................: '||LOGGING ,
'FORCE_LOGGING........................................: '||FORCE_LOGGING ,
'EXTENT_MANAGEMENT....................................: '||EXTENT_MANAGEMENT ,
'ALLOCATION_TYPE......................................: '||ALLOCATION_TYPE ,
'PLUGGED_IN...........................................: '||PLUGGED_IN ,
'SEGMENT_SPACE_MANAGEMENT ..........................: '||SEGMENT_SPACE_MANAGEMENT ,
'DEF_TAB_COMPRESSION..................................: '||DEF_TAB_COMPRESSION ,
'RETENTION............................................: '||RETENTION ,
'BIGFILE..............................................: '||BIGFILE ,
'PREDICATE_EVALUATION.................................: '||PREDICATE_EVALUATION,
'ENCRYPTED............................................: '||ENCRYPTED ,
'COMPRESS_FOR ........................................: '||COMPRESS_FOR ,
'DEF_INMEMORY.........................................: '||DEF_INMEMORY ,
'DEF_INMEMORY_PRIORITY................................: '||DEF_INMEMORY_PRIORITY ,
'DEF_INMEMORY_DISTRIBUTE.............................: '||DEF_INMEMORY_DISTRIBUTE ,
'DEF_INMEMORY_COMPRESSION.............................: '||DEF_INMEMORY_COMPRESSION ,
'DEF_INMEMORY_DUPLICATE...............................: '||DEF_INMEMORY_DUPLICATE ,
'SHARED...............................................: '||SHARED ,
'DEF_INDEX_COMPRESSION ...............................: '||DEF_INDEX_COMPRESSION ,
'INDEX_COMPRESS_FOR...................................: '||INDEX_COMPRESS_FOR ,
'DEF_CELLMEMORY ......................................: '||DEF_CELLMEMORY ,
'DEF_INMEMORY_SERVICE.................................: '||DEF_INMEMORY_SERVICE ,
'DEF_INMEMORY_SERVICE_NAME............................: '||DEF_INMEMORY_SERVICE_NAME,
'LOST_WRITE_PROTECT...................................: '||LOST_WRITE_PROTECT ,
'CHUNK_TABLESPACE ....................................: '||CHUNK_TABLESPACE
from dba_tablespaces
where 1=1
-- and TABLESPACE_NAME='XXX'
;
Tablespace metadata !!!
http://anuj-singh.blogspot.com/2011/11/oracle-tablespace-metadata.html
http://anuj-singh.blogspot.com/ How to Check Tablespace Creation Time in Oracle