ORA_DBA_TABLES - Copy of DBA_TABLES (currently not provided with snapshots)
Copy of DBA_TABLES (currently not provided with snapshots) information is stored in SAP table ORA_DBA_TABLES.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table ORA_DBA_TABLES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| OWNER | Oracle monitoring: Owner of the object | X | ORA_OWNER_30 | CHAR | 30 | |
| TABLE_NAME | Oracle monitoring: table name | X | ORA_TABLE_NAME | CHAR | 30 | |
| TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | X | ORA_TABLESPACE_NAME | CHAR | 30 | |
| CLUSTER_NAME | Oracle monitoring: cluster name | ORA_CLUSTER_NAME | CHAR | 30 | ||
| IOT_NAME | Oracle monitoring: IOT name | ORA_IOT_NAME | CHAR | 30 | ||
| PCT_FREE | Oracle monitoring:percentage of free space in a block | ORA_PCT_FREE | DEC | 12 | ||
| PCT_USED | Oracle monitoring: percentage of used space in a block | ORA_PCT_USED | DEC | 12 | ||
| INI_TRANS | Oracle monitoring: Initial number of transactions | ORA_INI_TRANS | DEC | 12 | ||
| MAX_TRANS | Oracle monitoring: Maximum number of transactions | ORA_MAX_TRANS | DEC | 12 | ||
| INITIAL_EXTENT | Oracle monitoring: Size of the initial extent in bytes | ORA_INITIAL_EXTENT | DEC | 12 | ||
| NEXT_EXTENT | Oracle monitor: Next extent | ORA_NEXT_EXTENT | DEC | 12 | ||
| MIN_EXTENTS | Oracle monitor: Minimum extent | ORA_MIN_EXTENTS | DEC | 12 | ||
| MAX_EXTENTS | Oracle monitor: Maximum extent | ORA_MAX_EXTENTS | DEC | 12 | ||
| PCT_INCREASE | Oracle monitor. PCT increase | ORA_PCT_INCREASE | DEC | 12 | ||
| FREELISTS | Oracle monitoring: Number of process freelists allocated | ORA_FREELISTS | DEC | 12 | ||
| FREELIST_GROUPS | Oracle monitoring: Number of freelist groups allocated | ORA_FREELIST_GROUPS | DEC | 12 | ||
| LOGGING | Oracle monitoring: Logging attribute | ORA_LOGGINGA | CHAR | 3 | ||
| BACKED_UP | Oracle monitoring: Has table been backed up since last chang | ORA_BACKED_UP | CHAR | 1 | ||
| NUM_ROWS | Oracle monitoring: Number of rows in the table | ORA_NUM_ROWS | DEC | 12 | ||
| BLOCKS | Oracle monitoring: Number of used data blocks in the table | ORA_BLOCKS_USED | DEC | 12 | ||
| EMPTY_BLOCKS | Oracle monitoring: Number of empty (never used) data blocks | ORA_EMPTY_BLOCKS | DEC | 12 | ||
| AVG_SPACE | Oracle monitoring: avg. free space (bytes) in a data block | ORA_AVG_SPACE | DEC | 12 | ||
| CHAIN_CNT | Oracle monitoring: Number of rows in table that are chained | ORA_CHAIN_CNT | DEC | 12 | ||
| AVG_ROW_LEN | Oracle monitoring: Average length of a row in table (bytes) | ORA_AVG_ROW_LEN | DEC | 12 | ||
| AVG_SPACE_FREE | Oracle monitoring: avg. freespace of all blocks on freelist | ORA_AVG_SPACE_FREE | DEC | 12 | ||
| NUM_FREELIST_BLK | Oracle monitoring: number of blocks on the freelist | ORA_NUM_FREELIST_BLK | DEC | 12 | ||
| DEGREE | Oracle monitoring: number of threads per instance for scan | ORA_DEGREE | DEC | 12 | ||
| INSTANCES | Oracle monitoring:inst. across which table is to be scanned | ORA_INSTANCES | CHAR | 10 | ||
| CACHE | Oracle monitoring:Whether the cluster is to be cached in buf | ORA_CACHE_DBA | CHAR | 5 | ||
| TABLE_LOCK | Oracle monitoring: Whether table locking is enabled or disab | ORA_TABLE_LOCK | CHAR | 8 | ||
| SAMPLE_SIZE | Oracle monitoring: Sample size used in analyzing this table | ORA_SAMPLE_SIZE | DEC | 12 | ||
| LAST_ANALYZED_D | Oracle monitoring: Date of last table analysis (date field) | ORA_LAST_ANALYZED_D | DATS | 8 | ||
| LAST_ANALYZED_T | Oracle monitoring: Date of last table analysis (time field) | ORA_LAST_ANALYZED_T | TIMS | 6 | ||
| PARTITIONED | Oracle monitoring: Indicates whether table is partitioned | ORA_PARTITIONED | CHAR | 3 | ||
| IOT_TYPE | Oracle monitoring: IOT type | ORA_IOT_TYPE | CHAR | 12 | ||
| TEMPORARY_DBA | Oracle monitoring: data visible which is placed by this sess | ORA_TEMPORARY | CHAR | 1 | ||
| SECONDARY | Oracle monitoring: Is trigger a secondary object | ORA_SECONDARY | CHAR | 1 | ||
| NESTED | Oracle monitoring: Is the table a nested table? | ORA_NESTED | CHAR | 3 | ||
| BUFFER_POOL | Oracle monitoring: The default buffer pool for the object | ORA_BUFFER_POOL | CHAR | 7 | ||
| ROW_MOVEMENT | Oracle monitoring: partitioned row movement is enabled ? | ORA_ROW_MOVEMENT | CHAR | 8 | ||
| GLOBAL_STATS | Oracle monitoring: Stats collected for whole table or estima | ORA_GLOBAL_STATS | CHAR | 3 | ||
| USER_STATS | Oracle monitoring: Were statistics entered directly by user? | ORA_USER_STATS | CHAR | 3 | ||
| DURATION | Oracle monitoring: duration of a temporary table | ORA_DURATION | CHAR | 15 | ||
| SKIP_CORRUPT | Oracle monitoring: If Oracle ignores blocks marked corrupt | ORA_SKIP_CORRUPT | CHAR | 8 | ||
| MONITORING | Oracle monitoring: table has the MONITORING attribute set | ORA_MONITORING | CHAR | 3 | ||
| CLUSTER_OWNER | Oracle monitoring: Cluster owner | ORA_CLUSTER_OWNER | CHAR | 30 | ||
| DEPENDENCIES | Oracle monitoring: Dependencies | ORA_DEPENDENCIES | CHAR | 8 | ||
| COMPRESSION | Oracle monitoring: Compression | ORA_COMPRESSION | CHAR | 8 |