eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_TABLES

Object Details

Object Name:	ALL_TABLES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of relational tables accessible to the user

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

SYS.ALL_TABLES references the following:

SYS: DEFERRED_STG$; OBJ$; OBJAUTH$; SEG$; TAB$; TS$; USER$

SYS.ALL_TABLES is referenced by following:

APPS: AMS_LIST_RUNNING_TOTAL_PVT - show dependent code; ARP_CMERGE_MASTER - show dependent code; AS_IMPORT_SL_PVT - show dependent code; EGO_USER_ATTRS_COMMON_PVT - show dependent code
PUBLIC: ALL_TABLES
SYS: ALL_ALL_TABLES; ALL_APPLY_DML_CONF_HANDLERS; ALL_APPLY_DML_HANDLERS; ALL_APPLY_HANDLE_COLLISIONS; ALL_APPLY_REPERROR_HANDLERS; ALL_AUDIT_POLICIES; ALL_AUDIT_POLICY_COLUMNS; ALL_CAPTURE_PREPARED_TABLES; ALL_CLUSTERING_DIMENSIONS; ALL_CLUSTERING_JOINS; ALL_CLUSTERING_KEYS; ALL_CLUSTERING_TABLES; ALL_POLICIES; ALL_POLICY_ATTRIBUTES; ALL_POLICY_CONTEXTS; ALL_POLICY_GROUPS; ALL_SEC_RELEVANT_COLS; ALL_SOURCE_TAB_COLUMNS; ALL_SYNC_CAPTURE_PREPARED_TABS; ALL_TAB_COL_STATISTICS; ALL_XMLTYPE_COLS; DBA_SOURCE_TAB_COLUMNS; DBMS_AW - show dependent code; DBMS_AW_EXP - show dependent code; DBMS_CDC_IMPDPV - show dependent code; DBMS_COMPARISON - show dependent code; DBMS_CUBE_LOG - show dependent code; DBMS_DBFS_SFS - show dependent code; DBMS_PARALLEL_EXECUTE - show dependent code; DBMS_PARALLEL_EXECUTE_INTERNAL - show dependent code; DBMS_SCHED_MAIN_EXPORT - show dependent code; DBMS_SQLTCB_INTERNAL - show dependent code; DBMS_SWRF_INTERNAL - show dependent code; DMP_SEC - show dependent code; PRVT_COMPRESSION - show dependent code; USER_PUBLISHED_COLUMNS; USER_SOURCE_TABLES; USER_SOURCE_TAB_COLUMNS