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? |