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