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.USER_ALL_TABLES

Object Details

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

Description of all object and relational tables owned by the user's

[View Source]

Columns

Name	Datatype	Length	Comments
TABLE_NAME	VARCHAR2	(128)	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
OBJECT_ID_TYPE	VARCHAR2	(16)	If user-defined OID, then USER-DEFINED, else if system generated OID, then SYST EM GENERATED
TABLE_TYPE_OWNER	VARCHAR2	(128)	Owner of the type of the table if the table is an object table
TABLE_TYPE	VARCHAR2	(128)	Type of the table if the table is an object table
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
SEGMENT_CREATED	VARCHAR2	(3)	Whether the table segment is created or not
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 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
,      OBJECT_ID_TYPE
,      TABLE_TYPE_OWNER
,      TABLE_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
,      SEGMENT_CREATED
,      INMEMORY
,      INMEMORY_PRIORITY
,      INMEMORY_DISTRIBUTE
,      INMEMORY_COMPRESSION
,      INMEMORY_DUPLICATE
FROM SYS.USER_ALL_TABLES;

Dependencies

[top of page]

SYS.USER_ALL_TABLES references the following:

SYS: USER_OBJECT_TABLES; USER_TABLES

SYS.USER_ALL_TABLES is referenced by following:

PUBLIC: USER_ALL_TABLES
SYS: USER_TSTZ_TAB_COLS