Data Element list used by SAP ABAP Table ORA_DBA_TABLES (Copy of DBA_TABLES (currently not provided with snapshots))
SAP ABAP Table
ORA_DBA_TABLES (Copy of DBA_TABLES (currently not provided with snapshots)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORA_AVG_ROW_LEN | Oracle monitoring: Average length of a row in table (bytes) | ||
| 2 | ORA_AVG_SPACE | Oracle monitoring: avg. free space (bytes) in a data block | ||
| 3 | ORA_AVG_SPACE_FREE | Oracle monitoring: avg. freespace of all blocks on freelist | ||
| 4 | ORA_BACKED_UP | Oracle monitoring: Has table been backed up since last chang | ||
| 5 | ORA_BLOCKS_USED | Oracle monitoring: Number of used data blocks in the table | ||
| 6 | ORA_BUFFER_POOL | Oracle monitoring: The default buffer pool for the object | ||
| 7 | ORA_CACHE_DBA | Oracle monitoring:Whether the cluster is to be cached in buf | ||
| 8 | ORA_CHAIN_CNT | Oracle monitoring: Number of rows in table that are chained | ||
| 9 | ORA_CLUSTER_NAME | Oracle monitoring: cluster name | ||
| 10 | ORA_CLUSTER_OWNER | Oracle monitoring: Cluster owner | ||
| 11 | ORA_COMPRESSION | Oracle monitoring: Compression | ||
| 12 | ORA_DEGREE | Oracle monitoring: number of threads per instance for scan | ||
| 13 | ORA_DEPENDENCIES | Oracle monitoring: Dependencies | ||
| 14 | ORA_DURATION | Oracle monitoring: duration of a temporary table | ||
| 15 | ORA_EMPTY_BLOCKS | Oracle monitoring: Number of empty (never used) data blocks | ||
| 16 | ORA_FREELISTS | Oracle monitoring: Number of process freelists allocated | ||
| 17 | ORA_FREELIST_GROUPS | Oracle monitoring: Number of freelist groups allocated | ||
| 18 | ORA_GLOBAL_STATS | Oracle monitoring: Stats collected for whole table or estima | ||
| 19 | ORA_INITIAL_EXTENT | Oracle monitoring: Size of the initial extent in bytes | ||
| 20 | ORA_INI_TRANS | Oracle monitoring: Initial number of transactions | ||
| 21 | ORA_INSTANCES | Oracle monitoring:inst. across which table is to be scanned | ||
| 22 | ORA_IOT_NAME | Oracle monitoring: IOT name | ||
| 23 | ORA_IOT_TYPE | Oracle monitoring: IOT type | ||
| 24 | ORA_LAST_ANALYZED_D | Oracle monitoring: Date of last table analysis (date field) | ||
| 25 | ORA_LAST_ANALYZED_T | Oracle monitoring: Date of last table analysis (time field) | ||
| 26 | ORA_LOGGINGA | Oracle monitoring: Logging attribute | ||
| 27 | ORA_MAX_EXTENTS | Oracle monitor: Maximum extent | ||
| 28 | ORA_MAX_TRANS | Oracle monitoring: Maximum number of transactions | ||
| 29 | ORA_MIN_EXTENTS | Oracle monitor: Minimum extent | ||
| 30 | ORA_MONITORING | Oracle monitoring: table has the MONITORING attribute set | ||
| 31 | ORA_NESTED | Oracle monitoring: Is the table a nested table? | ||
| 32 | ORA_NEXT_EXTENT | Oracle monitor: Next extent | ||
| 33 | ORA_NUM_FREELIST_BLK | Oracle monitoring: number of blocks on the freelist | ||
| 34 | ORA_NUM_ROWS | Oracle monitoring: Number of rows in the table | ||
| 35 | ORA_OWNER_30 | Oracle monitoring: Owner of the object | ||
| 36 | ORA_PARTITIONED | Oracle monitoring: Indicates whether table is partitioned | ||
| 37 | ORA_PCT_FREE | Oracle monitoring:percentage of free space in a block | ||
| 38 | ORA_PCT_INCREASE | Oracle monitor. PCT increase | ||
| 39 | ORA_PCT_USED | Oracle monitoring: percentage of used space in a block | ||
| 40 | ORA_ROW_MOVEMENT | Oracle monitoring: partitioned row movement is enabled ? | ||
| 41 | ORA_SAMPLE_SIZE | Oracle monitoring: Sample size used in analyzing this table | ||
| 42 | ORA_SECONDARY | Oracle monitoring: Is trigger a secondary object | ||
| 43 | ORA_SKIP_CORRUPT | Oracle monitoring: If Oracle ignores blocks marked corrupt | ||
| 44 | ORA_SNAPSHOT_ID | Oracle monitor: snapshot ID | ||
| 45 | ORA_TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | ||
| 46 | ORA_TABLE_LOCK | Oracle monitoring: Whether table locking is enabled or disab | ||
| 47 | ORA_TABLE_NAME | Oracle monitoring: table name | ||
| 48 | ORA_TEMPORARY | Oracle monitoring: data visible which is placed by this sess | ||
| 49 | ORA_USER_STATS | Oracle monitoring: Were statistics entered directly by user? |