「Oracle」表領域を確認する方法
SQL構文
SELECT * FROM DBA_TABLESPACES;
結果
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION BIGFILE PREDICATE_EVALUATION ENCRYPTED COMPRESS_FOR DEF_INMEMORY DEF_INMEMORY_PRIORITY DEF_INMEMORY_DISTRIBUTE DEF_INMEMORY_COMPRESSION DEF_INMEMORY_DUPLICATE SHARED DEF_INDEX_COMPRESSION INDEX_COMPRESS_FOR DEF_CELLMEMORY DEF_INMEMORY_SERVICE DEF_INMEMORY_SERVICE_NAME LOST_WRITE_PROTECT CHUNK_TABLESPACE
SYSTEM 8192 65536 (NULL) 1 2147483645 2147483645 (NULL) 65536 ONLINE PERMANENT LOGGING YES LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO HOST NO (NULL) DISABLED (NULL) (NULL) (NULL) (NULL) SHARED DISABLED (NULL) (NULL) (NULL) (NULL) OFF N
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION BIGFILE PREDICATE_EVALUATION ENCRYPTED COMPRESS_FOR DEF_INMEMORY DEF_INMEMORY_PRIORITY DEF_INMEMORY_DISTRIBUTE DEF_INMEMORY_COMPRESSION DEF_INMEMORY_DUPLICATE SHARED DEF_INDEX_COMPRESSION INDEX_COMPRESS_FOR DEF_CELLMEMORY DEF_INMEMORY_SERVICE DEF_INMEMORY_SERVICE_NAME LOST_WRITE_PROTECT CHUNK_TABLESPACE
SYSTEM 8192 65536 (NULL) 1 2147483645 2147483645 (NULL) 65536 ONLINE PERMANENT LOGGING YES LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO HOST NO (NULL) DISABLED (NULL) (NULL) (NULL) (NULL) SHARED DISABLED (NULL) (NULL) (NULL) (NULL) OFF N
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION BIGFILE PREDICATE_EVALUATION ENCRYPTED COMPRESS_FOR DEF_INMEMORY DEF_INMEMORY_PRIORITY DEF_INMEMORY_DISTRIBUTE DEF_INMEMORY_COMPRESSION DEF_INMEMORY_DUPLICATE SHARED DEF_INDEX_COMPRESSION INDEX_COMPRESS_FOR DEF_CELLMEMORY DEF_INMEMORY_SERVICE DEF_INMEMORY_SERVICE_NAME LOST_WRITE_PROTECT CHUNK_TABLESPACE SYSTEM 8192 65536 (NULL) 1 2147483645 2147483645 (NULL) 65536 ONLINE PERMANENT LOGGING YES LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO HOST NO (NULL) DISABLED (NULL) (NULL) (NULL) (NULL) SHARED DISABLED (NULL) (NULL) (NULL) (NULL) OFF N
項目
1.TABLESPACE 表領域の名前
2.BLOCK_SIZE ブロックサイズ
3.LOGGING ロギングモード
4.ALLOCATION_TYPE 有効なエクステント割当てのタイプ
5.DEF_TAB_COMPRESSION デフォルトの表圧縮