|
tand(o.flags, 128) = 0
and t.bobj# = co.obj# (+)
and t.ts# = ts.ts#
and t.file# = s.file# (+)
and t.block# = s.block# (+)
and t.ts# = s.ts# (+)
and t.obj# = ds.obj# (+)
and t.dataobj# = cx.obj# (+)
and cx.owner# = cu.user# (+)
and ksppi.indx = ksppcv.indx
and ksppi.ksppinm = '_dml_monitoring_enabled'
;
comment on table USER_TABLES is 'Description of the user''s own relational tables';
comment on column USER_TABLES.TABLE_NAME is 'Name of the table';
comment on column USER_TABLES.TABLESPACE_NAME is 'Name of the tablespace containing the table';
comment on column USER_TABLES.CLUSTER_NAME is 'Name of the cluster, if any, to which the table belongs';
comment on column USER_TABLES.IOT_NAME is 'Name of the index-only table, if any, to which the overflow or mapping table entry belongs';
comment on column USER_TABLES.STATUS is 'Status of the table will be UNUSABLE if a previous DROP TABLE operation failed,
VALID otherwise';
comment on column USER_TABLES.PCT_FREE is 'Minimum percentage of free space in a block';
comment on column USER_TABLES.PCT_USED is 'Minimum percentage of used space in a block';
comment on column USER_TABLES.INI_TRANS is 'Initial number of transactions';
comment on column USER_TABLES.MAX_TRANS is 'Maximum number of transactions';
comment on column USER_TABLES.INITIAL_EXTENT is 'Size of the initial extent in bytes';
comment on column USER_TABLES.NEXT_EXTENT is 'Size of secondary extents in bytes';
comment on column USER_TABLES.MIN_EXTENTS is 'Minimum number of extents allowed in the segment';
comment on column USER_TABLES.MAX_EXTENTS is 'Maximum number of extents allowed in the segment';
comment on column USER_TABLES.PCT_INCREASE is 'Percentage increase in extent size';
comment on column USER_TABLES.FREELISTS is 'Number of process freelists allocated in this segment';
comment on column USER_TABLES.FREELIST_GROUPS is 'Number of freelist groups allocated in this segment';
comment on column USER_TABLES.LOGGING is 'Logging attribute';
comment on column USER_TABLES.BACKED_UP is 'Has table been backed up since last modification?';
comment on column USER_TABLES.NUM_ROWS is 'The number of rows in the table';
comment on column USER_TABLES.BLOCKS is 'The number of used blocks in the table';
comment on column USER_TABLES.EMPTY_BLOCKS is 'The number of empty (never used) blocks in the table';
comment on column USER_TABLES.AVG_SPACE is 'The average available free space in the table';
comment on column USER_TABLES.CHAIN_CNT is 'The number of chained rows in the table';
comment on column USER_TABLES.AVG_ROW_LEN is 'The average row length, including row overhead';
comment on column USER_TABLES.AVG_SPACE_FREELIST_BLOCKS is 'The average freespace of all blocks on a freelist';
comment on column USER_TABLES.NUM_FREELIST_BLOCKS is 'The number of blocks on the freelist';
comment on column USER_TABLES.DEGREE is 'The number of threads per instance for scanning the table';
comment on column USER_TABLES.INSTANCES is 'The number of instances across which the table is to be scanned';
comment on column USER_TABLES.CACHE is 'Whether the table is to be cached in the buffer cache';
comment on column USER_TABLES.TABLE_LOCK is 'Whether table locking is enabled or disabled';
comment on column USER_TABLES.SAMPLE_SIZE is 'The sample size used in analyzing this table';
comment on column USER_TABLES.LAST_ANALYZED is 'The date of the most recent time this tabl |