SAP ABAP Table ORA_DBA_TABLES (Copy of DBA_TABLES (currently not provided with snapshots))
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English
Basic Data
Table Category TRANSP    Transparent table 
Transparent table ORA_DBA_TABLES   Table Relationship Diagram
Short Description Copy of DBA_TABLES (currently not provided with snapshots)    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 SNAPSHOT_ID ORA_SNAPSHOT_ID ORA_SNAPSHOT_ID NUMC 10   0   Oracle monitor: snapshot ID *
2 OWNER ORA_OWNER_30 ORA_CHAR_30 CHAR 30   0   Oracle monitoring: Owner of the object  
3 TABLE_NAME ORA_TABLE_NAME ORA_CHAR_30 CHAR 30   0   Oracle monitoring: table name  
4 TABLESPACE_NAME ORA_TABLESPACE_NAME ORA_CHAR_30 CHAR 30   0   Oracle monitoring: Tablespacename to which objects belong  
5 CLUSTER_NAME ORA_CLUSTER_NAME ORA_CHAR_30 CHAR 30   0   Oracle monitoring: cluster name  
6 IOT_NAME ORA_IOT_NAME ORA_CHAR_30 CHAR 30   0   Oracle monitoring: IOT name  
7 PCT_FREE ORA_PCT_FREE ORA_NUM_22 DEC 22   0   Oracle monitoring:percentage of free space in a block  
8 PCT_USED ORA_PCT_USED ORA_NUM_22 DEC 22   0   Oracle monitoring: percentage of used space in a block  
9 INI_TRANS ORA_INI_TRANS ORA_NUM_22 DEC 22   0   Oracle monitoring: Initial number of transactions  
10 MAX_TRANS ORA_MAX_TRANS ORA_NUM_22 DEC 22   0   Oracle monitoring: Maximum number of transactions  
11 INITIAL_EXTENT ORA_INITIAL_EXTENT ORA_NUM_22 DEC 22   0   Oracle monitoring: Size of the initial extent in bytes  
12 NEXT_EXTENT ORA_NEXT_EXTENT ORA_NUM_22 DEC 22   0   Oracle monitor: Next extent  
13 MIN_EXTENTS ORA_MIN_EXTENTS ORA_NUM_22 DEC 22   0   Oracle monitor: Minimum extent  
14 MAX_EXTENTS ORA_MAX_EXTENTS ORA_NUM_22 DEC 22   0   Oracle monitor: Maximum extent  
15 PCT_INCREASE ORA_PCT_INCREASE ORA_NUM_22 DEC 22   0   Oracle monitor. PCT increase  
16 FREELISTS ORA_FREELISTS ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of process freelists allocated  
17 FREELIST_GROUPS ORA_FREELIST_GROUPS ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of freelist groups allocated  
18 LOGGING ORA_LOGGINGA ORA_CHAR_3 CHAR 3   0   Oracle monitoring: Logging attribute  
19 BACKED_UP ORA_BACKED_UP ORA_CHAR_1 CHAR 1   0   Oracle monitoring: Has table been backed up since last chang  
20 NUM_ROWS ORA_NUM_ROWS ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of rows in the table  
21 BLOCKS ORA_BLOCKS_USED ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of used data blocks in the table  
22 EMPTY_BLOCKS ORA_EMPTY_BLOCKS ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of empty (never used) data blocks  
23 AVG_SPACE ORA_AVG_SPACE ORA_NUM_22 DEC 22   0   Oracle monitoring: avg. free space (bytes) in a data block  
24 CHAIN_CNT ORA_CHAIN_CNT ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of rows in table that are chained  
25 AVG_ROW_LEN ORA_AVG_ROW_LEN ORA_NUM_22 DEC 22   0   Oracle monitoring: Average length of a row in table (bytes)  
26 AVG_SPACE_FREE ORA_AVG_SPACE_FREE ORA_NUM_22 DEC 22   0   Oracle monitoring: avg. freespace of all blocks on freelist  
27 NUM_FREELIST_BLK ORA_NUM_FREELIST_BLK ORA_NUM_22 DEC 22   0   Oracle monitoring: number of blocks on the freelist  
28 DEGREE ORA_DEGREE ORA_DEC_22 DEC 22   0   Oracle monitoring: number of threads per instance for scan  
29 INSTANCES ORA_INSTANCES ORA_CHAR_10 CHAR 10   0   Oracle monitoring:inst. across which table is to be scanned  
30 CACHE ORA_CACHE_DBA ORA_CHAR_5 CHAR 5   0   Oracle monitoring:Whether the cluster is to be cached in buf  
31 TABLE_LOCK ORA_TABLE_LOCK ORA_CHAR_8 CHAR 8   0   Oracle monitoring: Whether table locking is enabled or disab  
32 SAMPLE_SIZE ORA_SAMPLE_SIZE ORA_NUM_22 DEC 22   0   Oracle monitoring: Sample size used in analyzing this table  
33 LAST_ANALYZED_D ORA_LAST_ANALYZED_D ORA_DATE DATS 8   0   Oracle monitoring: Date of last table analysis (date field)  
34 LAST_ANALYZED_T ORA_LAST_ANALYZED_T ORA_TIME TIMS 6   0   Oracle monitoring: Date of last table analysis (time field)  
35 PARTITIONED ORA_PARTITIONED ORA_CHAR_3 CHAR 3   0   Oracle monitoring: Indicates whether table is partitioned  
36 IOT_TYPE ORA_IOT_TYPE ORA_CHAR_12 CHAR 12   0   Oracle monitoring: IOT type  
37 TEMPORARY_DBA ORA_TEMPORARY ORA_CHAR_1 CHAR 1   0   Oracle monitoring: data visible which is placed by this sess  
38 SECONDARY ORA_SECONDARY ORA_CHAR_1 CHAR 1   0   Oracle monitoring: Is trigger a secondary object  
39 NESTED ORA_NESTED ORA_CHAR_3 CHAR 3   0   Oracle monitoring: Is the table a nested table?  
40 BUFFER_POOL ORA_BUFFER_POOL ORA_CHAR_7 CHAR 7   0   Oracle monitoring: The default buffer pool for the object  
41 ROW_MOVEMENT ORA_ROW_MOVEMENT ORA_CHAR_8 CHAR 8   0   Oracle monitoring: partitioned row movement is enabled ?  
42 GLOBAL_STATS ORA_GLOBAL_STATS ORA_CHAR_3 CHAR 3   0   Oracle monitoring: Stats collected for whole table or estima  
43 USER_STATS ORA_USER_STATS ORA_CHAR_3 CHAR 3   0   Oracle monitoring: Were statistics entered directly by user?  
44 DURATION ORA_DURATION ORA_CHAR_15 CHAR 15   0   Oracle monitoring: duration of a temporary table  
45 SKIP_CORRUPT ORA_SKIP_CORRUPT ORA_CHAR_8 CHAR 8   0   Oracle monitoring: If Oracle ignores blocks marked corrupt  
46 MONITORING ORA_MONITORING ORA_CHAR_3 CHAR 3   0   Oracle monitoring: table has the MONITORING attribute set  
47 CLUSTER_OWNER ORA_CLUSTER_OWNER ORA_CHAR_30 CHAR 30   0   Oracle monitoring: Cluster owner  
48 DEPENDENCIES ORA_DEPENDENCIES ORA_CHAR_8 CHAR 8   0   Oracle monitoring: Dependencies  
49 COMPRESSION ORA_COMPRESSION ORA_CHAR_8 CHAR 8   0   Oracle monitoring: Compression  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700