[Home] [Help] [Dependency Information]
Object Name: | ALL_TABLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of relational tables accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the table |
TABLE_NAME | VARCHAR2 | (128) | Yes | Name of the table |
TABLESPACE_NAME | VARCHAR2 | (30) | Name of the tablespace containing the table | |
CLUSTER_NAME | VARCHAR2 | (128) | Name of the cluster, if any, to which the table belongs | |
IOT_NAME | VARCHAR2 | (128) | Name of the index-only table, if any, to which the overflow or mapping table entry belongs | |
STATUS | VARCHAR2 | (8) | Status of the table will be UNUSABLE if a previous DROP TABLE operation failed, VALID otherwise | |
PCT_FREE | NUMBER | Minimum percentage of free space in a block | ||
PCT_USED | NUMBER | Minimum percentage of used space in a block | ||
INI_TRANS | NUMBER | Initial number of transactions | ||
MAX_TRANS | NUMBER | Maximum number of transactions | ||
INITIAL_EXTENT | NUMBER | Size of the initial extent in bytes | ||
NEXT_EXTENT | NUMBER | Size of secondary extents in bytes | ||
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment | ||
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment | ||
PCT_INCREASE | NUMBER | Percentage increase in extent size | ||
FREELISTS | NUMBER | Number of process freelists allocated in this segment | ||
FREELIST_GROUPS | NUMBER | Number of freelist groups allocated in this segment | ||
LOGGING | VARCHAR2 | (3) | Logging attribute | |
BACKED_UP | VARCHAR2 | (1) | Has table been backed up since last modification? | |
NUM_ROWS | NUMBER | The number of rows in the table | ||
BLOCKS | NUMBER | The number of used blocks in the table | ||
EMPTY_BLOCKS | NUMBER | The number of empty (never used) blocks in the table | ||
AVG_SPACE | NUMBER | The average available free space in the table | ||
CHAIN_CNT | NUMBER | The number of chained rows in the table | ||
AVG_ROW_LEN | NUMBER | The average row length, including row overhead | ||
AVG_SPACE_FREELIST_BLOCKS | NUMBER | The average freespace of all blocks on a freelist | ||
NUM_FREELIST_BLOCKS | NUMBER | The number of blocks on the freelist | ||
DEGREE | VARCHAR2 | (10) | The number of threads per instance for scanning the table | |
INSTANCES | VARCHAR2 | (10) | The number of instances across which the table is to be scanned | |
CACHE | VARCHAR2 | (5) | Whether the table is to be cached in the buffer cache | |
TABLE_LOCK | VARCHAR2 | (8) | Whether table locking is enabled or disabled | |
SAMPLE_SIZE | NUMBER | The sample size used in analyzing this table | ||
LAST_ANALYZED | DATE | The date of the most recent time this table was analyzed | ||
PARTITIONED | VARCHAR2 | (3) | Is this table partitioned? YES or NO | |
IOT_TYPE | VARCHAR2 | (12) | If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL | |
TEMPORARY | VARCHAR2 | (1) | Can the current session only see data that it place in this object itself? | |
SECONDARY | VARCHAR2 | (1) | Is this table object created as part of icreate for domain indexes? | |
NESTED | VARCHAR2 | (3) | Is the table a nested table? | |
BUFFER_POOL | VARCHAR2 | (7) | The default buffer pool to be used for table blocks | |
FLASH_CACHE | VARCHAR2 | (7) | The default flash cache hint to be used for table blocks | |
CELL_FLASH_CACHE | VARCHAR2 | (7) | The default cell flash cache hint to be used for table blocks | |
ROW_MOVEMENT | VARCHAR2 | (8) | Whether partitioned row movement is enabled or disabled | |
GLOBAL_STATS | VARCHAR2 | (3) | Are the statistics calculated without merging underlying partitions? | |
USER_STATS | VARCHAR2 | (3) | Were the statistics entered directly by the user? | |
DURATION | VARCHAR2 | (15) | If temporary table, then duration is sys$session or sys$transaction else NULL | |
SKIP_CORRUPT | VARCHAR2 | (8) | Whether skip corrupt blocks is enabled or disabled | |
MONITORING | VARCHAR2 | (3) | Should we keep track of the amount of modification? | |
CLUSTER_OWNER | VARCHAR2 | (128) | Owner of the cluster, if any, to which the table belongs | |
DEPENDENCIES | VARCHAR2 | (8) | Should we keep track of row level dependencies? | |
COMPRESSION | VARCHAR2 | (8) | Whether table compression is enabled or not | |
COMPRESS_FOR | VARCHAR2 | (30) | Compress what kind of operations | |
DROPPED | VARCHAR2 | (3) | Whether table is dropped and is in Recycle Bin | |
READ_ONLY | VARCHAR2 | (3) | Whether table is read only or not | |
SEGMENT_CREATED | VARCHAR2 | (3) | Whether the table segment is created or not | |
RESULT_CACHE | VARCHAR2 | (7) | The result cache mode annotation for the table | |
CLUSTERING | VARCHAR2 | (3) | Whether table has clustering clause or not | |
ACTIVITY_TRACKING | VARCHAR2 | (23) | ILM activity tracking mode | |
DML_TIMESTAMP | VARCHAR2 | (25) | ILM row modification or creation timestamp tracking mode | |
HAS_IDENTITY | VARCHAR2 | (3) | Whether the table has an identity column | |
CONTAINER_DATA | VARCHAR2 | (3) | An indicator of whether the table contains Container-specific data | |
INMEMORY | VARCHAR2 | (8) | Whether in-memory is enabled or not | |
INMEMORY_PRIORITY | VARCHAR2 | (8) | User defined priority in which in-memory column store object is loaded | |
INMEMORY_DISTRIBUTE | VARCHAR2 | (15) | How the in-memory columnar store object is distributed | |
INMEMORY_COMPRESSION | VARCHAR2 | (17) | Compression level for the in-memory column store option | |
INMEMORY_DUPLICATE | VARCHAR2 | (13) | How the in-memory column store object is duplicated |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TABLE_NAME
, TABLESPACE_NAME
, CLUSTER_NAME
, IOT_NAME
, STATUS
, PCT_FREE
, PCT_USED
, INI_TRANS
, MAX_TRANS
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENTS
, MAX_EXTENTS
, PCT_INCREASE
, FREELISTS
, FREELIST_GROUPS
, LOGGING
, BACKED_UP
, NUM_ROWS
, BLOCKS
, EMPTY_BLOCKS
, AVG_SPACE
, CHAIN_CNT
, AVG_ROW_LEN
, AVG_SPACE_FREELIST_BLOCKS
, NUM_FREELIST_BLOCKS
, DEGREE
, INSTANCES
, CACHE
, TABLE_LOCK
, SAMPLE_SIZE
, LAST_ANALYZED
, PARTITIONED
, IOT_TYPE
, TEMPORARY
, SECONDARY
, NESTED
, BUFFER_POOL
, FLASH_CACHE
, CELL_FLASH_CACHE
, ROW_MOVEMENT
, GLOBAL_STATS
, USER_STATS
, DURATION
, SKIP_CORRUPT
, MONITORING
, CLUSTER_OWNER
, DEPENDENCIES
, COMPRESSION
, COMPRESS_FOR
, DROPPED
, READ_ONLY
, SEGMENT_CREATED
, RESULT_CACHE
, CLUSTERING
, ACTIVITY_TRACKING
, DML_TIMESTAMP
, HAS_IDENTITY
, CONTAINER_DATA
, INMEMORY
, INMEMORY_PRIORITY
, INMEMORY_DISTRIBUTE
, INMEMORY_COMPRESSION
, INMEMORY_DUPLICATE
FROM SYS.ALL_TABLES;
|
|
|