Oracle “dba_tables”介绍

摘要:
DBA_ TABLES描述了数据库中的所有相关表。它的列与ALL_ TABLES中的列相同。要获取此视图的统计信息,请使用ANALYZE SQL语句。ALL_ TABLS描述了这些相关表的访问

  DBA_TABLES describes all relational tables in the database. Its columns are the same as those in ALL_TABLES. To gather statistics for this view, use the ANALYZE SQL statement.

ALL_TABLES describes the relational tables accessible to the current user. To gather statistics for this view, use the ANALYZE SQL statement.

Related Views

  • DBA_TABLES describes all relational tables in the database.

  • USER_TABLES describes the relational tables owned by the current user. This view does not display the OWNER column.

Note:

Columns marked with an asterisk (*) are populated only if you collect statistics on the table with the ANALYZE statement or theDBMS_STATS package.
ColumnDatatypeNULLDescription
OWNERVARCHAR2(30)NOT NULLOwner of the table
TABLE_NAMEVARCHAR2(30)NOT NULLName of the table
TABLESPACE_NAMEVARCHAR2(30) Name of the tablespace containing the table; null for partitioned, temporary, and index-organized tables
CLUSTER_NAMEVARCHAR2(30) Name of the cluster, if any, to which the table belongs
IOT_NAMEVARCHAR2(30) Name of the index-organized table, if any, to which the overflow or mapping table entry belongs. If the IOT_TYPE column is not null, then this column contains the base table name.
STATUSVARCHAR2(8) If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)
PCT_FREENUMBER Minimum percentage of free space in a block; null for partitioned tables
PCT_USEDNUMBER Minimum percentage of used space in a block; null for partitioned tables
INI_TRANSNUMBER Initial number of transactions; null for partitioned tables
MAX_TRANSNUMBER Maximum number of transactions; null for partitioned tables
INITIAL_EXTENTNUMBER Size of the initial extent (in bytes); null for partitioned tables
NEXT_EXTENTNUMBER Size of secondary extents (in bytes); null for partitioned tables
MIN_EXTENTSNUMBER Minimum number of extents allowed in the segment; null for partitioned tables
MAX_EXTENTSNUMBER Maximum number of extents allowed in the segment; null for partitioned tables
PCT_INCREASENUMBER Percentage increase in extent size; null for partitioned tables
FREELISTSNUMBER Number of process freelists allocated to the segment; null for partitioned tables
FREELIST_GROUPSNUMBER Number of freelist groups allocated to the segment; null for partitioned tables
LOGGINGVARCHAR2(3) Logging attribute; NULL for partitioned tables
BACKED_UPVARCHAR2(1) Has table been backed up since last change
NUM_ROWS*NUMBER Number of rows in the table
BLOCKS*NUMBER Number of used data blocks in the table
EMPTY_BLOCKS*NUMBER Number of empty (never used) data blocks in the table
AVG_SPACE*NUMBER Average amount of free space, in bytes, in a data block allocated to the table
CHAIN_CNT*NUMBER Number of rows in the table that are chained from one data block to another, or which have migrated to a new block, requiring a link to preserve the old ROWID
AVG_ROW_LEN*NUMBER Average length of a row in the table (in bytes)
AVG_SPACE_FREELIST _BLOCKSNUMBER Average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKSNUMBER Number of blocks on the freelist
DEGREEVARCHAR2(10) Number of threads per instance for scanning the table
INSTANCESVARCHAR2(10) Number of instances across which the table is to be scanned
CACHEVARCHAR2(5) Indicates whether the table is to be cached in the buffer cache (Y) or not (N)
TABLE_LOCKVARCHAR2(8) Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)
SAMPLE_SIZENUMBER Sample size used in analyzing this table
LAST_ANALYZEDDATE Date on which this table was most recently analyzed
PARTITIONEDVARCHAR2(3) Indicates whether this table is partitioned. Set to YES if it is partitioned.
IOT_TYPEVARCHAR2(12) If this is an index-organized table, then IOT_TYPE is IOTIOT_OVERFLOW, or IOT_MAPPING. If this is not an index-organized table, then IOT_TYPEis NULL.
TEMPORARYVARCHAR2(1) Can the current session only see data that it place in this object itself?
SECONDARYVARCHAR2(1) Whether the trigger is a secondary object created by theODCIIndexCreate method of the Oracle Data Cartridge (Y |N)
NESTEDVARCHAR2(3) Indicates whether the table is a nested table (YES) or not (NO)
BUFFER_POOLVARCHAR2(7) The default buffer pool for the object. NULL for partitioned tables
ROW_MOVEMENTVARCHAR2(8) Whether partitioned row movement is enabled or disabled
GLOBAL_STATSVARCHAR2(3) For partitioned tables, indicates whether statistics were collected for the table as a whole (YES) or were estimated from statistics on underlying partitions and subpartitions (NO)
USER_STATSVARCHAR2(3) Indicates whether statistics were entered directly by the user (YES) or not (NO)
DURATIONVARCHAR2(15) Indicates the duration of a temporary table:
  • SYS$SESSION: the rows are preserved for the duration of the session

  • SYS$TRANSACTION: the rows are deleted after COMMIT

Null for a permanent table

SKIP_CORRUPTVARCHAR2(8) Whether the Oracle Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED). To enable this feature, run the DBMS_REPAIR.SKIP_CORRUPT_BLOCKSprocedure.
MONITORINGVARCHAR2(3) Whether the table has the MONITORING attribute set
CLUSTER_OWNERVARCHAR2(30) Owner of the cluster, if any, to which the table belongs
DEPENDENCIESVARCHAR2(8) Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)
COMPRESSIONVARCHAR2(8) Indicates whether table compression is enabled (ENABLED) or not (DISABLED); null for partitioned tables
DROPPEDVARCHAR2(3) Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO); null for partitioned tables

免责声明:文章转载自《Oracle “dba_tables”介绍》仅用于学习参考。如对内容有疑问,请及时联系本站处理。

上篇XML与java的应用Ubuntu 安装Telnet服务下篇

宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=

相关文章