Thema:

Kommentar:
: Hi Netti, : ANALYZE und DBMS_STATS pflegen das Data Dictionary. Dazu gehört der Table USER_TABLES (u.va.). : Gruß : Gernot : USER_TABLES : Description of the user's own relational tables : Columns : ___________________________ : : TABLE_LOCK : Whether table locking is enabled or disabled : MIN_EXTENTS : Minimum number of extents allowed in the segment : DEGREE : The number of threads per instance for scanning the table : NUM_FREELIST_BLOCKS : The number of blocks on the freelist : AVG_SPACE_FREELIST_BLOCKS : The average freespace of all blocks on a freelist : TABLE_NAME : Name of the table : TABLESPACE_NAME : Name of the tablespace containing the table : CLUSTER_NAME : Name of the cluster, if any, to which the table belongs : IOT_NAME : Name of the index-only table, if any, to which the overflow entry belongs : PCT_FREE : Minimum percentage of free space in a block : PCT_USED : Minimum percentage of used space in a block : INI_TRANS : Initial number of transactions : MAX_TRANS : Maximum number of transactions : INSTANCES : The number of instances across which the table is to be scanned : NEXT_EXTENT : Size of secondary extents in bytes : BACKED_UP : Has table been backed up since last modification? : MAX_EXTENTS : Maximum number of extents allowed in the segment : PCT_INCREASE : Percentage increase in extent size : FREELISTS : Number of process freelists allocated in this segment : FREELIST_GROUPS : Number of freelist groups allocated in this segment : LOGGING : Logging attribute : NUM_ROWS : The number of rows in the table : LAST_ANALYZED : The date of the most recent time this table was analyzed : EMPTY_BLOCKS : The number of empty (never used) blocks in the table : AVG_SPACE : The average available free space in the table : CHAIN_CNT : The number of chained rows in the table : AVG_ROW_LEN : The average row length, including row overhead : INITIAL_EXTENT : Size of the initial extent in bytes : GLOBAL_STATS : Are the statistics calculated without merging underlying partitions? : MONITORING : Should we keep track of the amount of modification? : SKIP_CORRUPT : Whether skip corrupt blocks is enabled or disabled : USER_STATS : Were the statistics entered directly by the user? : ROW_MOVEMENT : Whether partitioned row movement is enabled or disabled : BUFFER_POOL : The default buffer pool to be used for table blocks : NESTED : Is the table a nested table? : SECONDARY : Is this table object created as part of icreate for domain indexes? : TEMPORARY : Can the current session only see data that it place in this object itself? : IOT_TYPE : If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL : CACHE : Whether the table is to be cached in the buffer cache : BLOCKS : The number of used blocks in the table : PARTITIONED : Is this table partitioned? YES or NO : SAMPLE_SIZE : The sample size used in analyzing this table : DURATION : If temporary table, then duration is sys$session or sys$transaction else NULL

Optionale Link URL:   
Link Titel:                  
Optionale Image URL: