| The views that follow describe the physical architecture of an Oracle 8i database - dba_data_files
- dba_extents
- dba_free_space
- dba_free_space_coalesced
- dba_objects
- dba_rollback_segs
- dba_segments
- dba_tablespaces
| dba_data_files | dba_extents |
|---|
| Contains information about database data files. | Contains information about extents composing all segments in the database. |
|
| | Name | Null? | Type | Name | Null? | Type |
|---|
| FILE_NAME | Y | VARCHAR2(513) | OWNER | Y | VARCHAR2(30) | | FILE_ID | Y | NUMBER | SEGMENT_NAME | Y | VARCHAR2(81) | | TABLESPACE_NAME | Y | VARCHAR2(30) | PARTITION_NAME | Y | VARCHAR2(30) | | BYTES | Y | NUMBER | SEGMENT_TYPE | Y | VARCHAR2(18) | | BLOCKS | Y | NUMBER | TABLESPACE_NAME | Y | VARCHAR2(30) | | STATUS | Y | VARCHAR2(9) | EXTENT_ID | Y | NUMBER | | RELATIVE_FNO | Y | NUMBER | FILE_ID | Y | NUMBER | | AUTOEXTENSIBLE | Y | VARCHAR2(3) | BLOCK_ID | Y | NUMBER | | MAXBYTES | Y | NUMBER | BYTES | Y | NUMBER | | MAXBLOCKS | Y | NUMBER | BLOCKS | Y | NUMBER | | INCREMENT_BY | Y | NUMBER | RELATIVE_FNO | Y | NUMBER | | USER_BYTES | Y | NUMBER | | | | | USER_BLOCKS | Y | NUMBER | | | |
| dba_free_space | dba_free_space_coalesced |
|---|
| Contains information about all free extents. | Contains statistics on coalesced space in the tablespaces. |
|
| | Name | Null? | Type | Name | Null? | Type |
|---|
| TABLESPACE_NAME | Y | VARCHAR2(30) | TABLESPACE_NAME | Y | VARCHAR2(30) | | FILE_ID | Y | NUMBER | TOTAL_EXTENTS | Y | NUMBER | | BLOCK_ID | Y | NUMBER | EXTENTS_COALESCED | Y | NUMBER | | BYTES | Y | NUMBER | PERCENT_EXTENTS_COALESCED | Y | NUMBER | | BLOCKS | Y | NUMBER | TOTAL_BYTES | Y | NUMBER | | RELATIVE_FNO | Y | NUMBER | BYTES_COALESCED | Y | NUMBER | | | | TOTAL_BLOCKS | Y | NUMBER | | | | BLOCKS_COALESCED | Y | NUMBER | | | | PERCENT_BLOCKS_COALESCED | Y | NUMBER |
| dba_objects | dba_rollback_segs |
|---|
| Contains information about all database objects. | Contains descriptions of the rollback segments. |
|
| | Name | Null? | Type | Name | Null? | Type |
|---|
| OWNER | Y | VARCHAR2(30) | SEGMENT_NAME | N | VARCHAR2(30) | | OBJECT_NAME | Y | VARCHAR2(128) | OWNER | Y | VARCHAR2(6) | | SUBOBJECT_NAME | Y | VARCHAR2(30) | TABLESPACE_NAME | N | VARCHAR2(30) | | OBJECT_ID | Y | NUMBER | SEGMENT_ID | N | NUMBER | | DATA_OBJECT_ID | Y | NUMBER | FILE_ID | N | NUMBER | | OBJECT_TYPE | Y | VARCHAR2(18) | BLOCK_ID | N | NUMBER | | CREATED | Y | DATE | INITIAL_EXTENT | Y | NUMBER | | LAST_DDL_TIME | Y | DATE | NEXT_EXTENT | Y | NUMBER | | TIMESTAMP | Y | VARCHAR2(19) | MIN_EXTENTS | N | NUMBER | | STATUS | Y | VARCHAR2(7) | MAX_EXTENTS | N | NUMBER | | TEMPORARY | Y | VARCHAR2(1) | PCT_INCREASE | Y | NUMBER | | GENERATED | Y | VARCHAR2(1) | STATUS | Y | VARCHAR2(16) | | SECONDARY | Y | VARCHAR2(1) | INSTANCE_NUM | Y | VARCHAR2(40) | | | | RELATIVE_FNO | N | NUMBER |
| dba_segments | dba_tablespaces |
|---|
| Contains information about storage allocated for all database segments. | Describes all tablespaces. |
|
| | Name | Null? | Type | Name | Null? | Type |
|---|
| OWNER | Y | VARCHAR2(30) | TABLESPACE_NAME | N | VARCHAR2(30) | | SEGMENT_NAME | Y | VARCHAR2(81) | INITIAL_EXTENT | Y | NUMBER | | PARTITION_NAME | Y | VARCHAR2(30) | NEXT_EXTENT | Y | NUMBER | | SEGMENT_TYPE | Y | VARCHAR2(18) | MIN_EXTENTS | N | NUMBER | | TABLESPACE_NAME | Y | VARCHAR2(30) | MAX_EXTENTS | N | NUMBER | | HEADER_FILE | Y | NUMBER | PCT_INCREASE | Y | NUMBER | | HEADER_BLOCK | Y | NUMBER | MIN_EXTLEN | Y | NUMBER | | BYTES | Y | NUMBER | STATUS | Y | VARCHAR2(9) | | BLOCKS | Y | NUMBER | CONTENTS | Y | VARCHAR2(9) | | EXTENTS | Y | NUMBER | LOGGING | Y | VARCHAR2(9) | | INITIAL_EXTENT | Y | NUMBER | EXTENT_MANAGEMENT | Y | VARCHAR2(10) | | NEXT_EXTENT | Y | NUMBER | ALLOCATION_TYPE | Y | VARCHAR2(9) | | MIN_EXTENTS | Y | NUMBER | PLUGGED_IN | Y | VARCHAR2(3) | | MAX_EXTENTS | Y | NUMBER | | | | | PCT_INCREASE | Y | NUMBER | | | | | FREELISTS | Y | NUMBER | | | | | FREELIST_GROUPS | Y | NUMBER | | | | | RELATIVE_FNO | Y | NUMBER | | | | | BUFFER_POOL | Y | VARCHAR2(7) | | | |
|
|