SAP ABAP Table ORAINDANAL (Detailed Analysis of Oracle Indexes (fr. V.7))
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 INTTAB    Structure 
Structure ORAINDANAL   Table Relationship Diagram
Short Description Detailed Analysis of Oracle Indexes (fr. V.7)    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 A_SIZE OA_SIZE DEC15 DEC 15   0   Allocated diskspace for an Oracle table  
2 A_BLOCKS OA_BLOCKS DEC11 DEC 11   0   Allocated blocks for an Oracle table  
3 A_EXTENTS OA_EXTENTS INT4 INT4 10   0   Allocated extents for an Oracle table  
4 INIT_EXT OINIT_EXT DEC15 DEC 15   0   Size of initial table extent  
5 NEXT_EXT ONEXT_EXT DEC15 DEC 15   0   Size of next extent  
6 MIN_EXTS OMIN_EXTS INT4 INT4 10   0   Oracle storage parameter 'minextents'  
7 MAX_EXTS OMAX_EXTS INT4 INT4 10   0   Oracle storage parameter 'maxextents'  
8 PCTINCR OPCTINCR INT2 INT2 5   0   Storage parameter 'pctincrease'  
9 BLKSIZE OBLKSIZE INT4 INT4 10   0   Oracle block size  
10 PCT_FREE OPCT_FREE INT2 INT2 5   0   Oracle storage parameter 'PCTFREE'  
11 P_PCT_FREE OP_PCT_FRE INT2 INT2 5   0   Recommended value for storage parameter 'PCTFREE'  
12 PCT_USED OPCT_USED INT2 INT2 5   0   Storage parameter 'PCTUSED'  
13 P_PCT_USED OP_PCT_USE INT2 INT2 5   0   Recommended value for storage parameter 'PCTUSED'  
14 INI_TRANS OINI_TRANS INT2 INT2 5   0   Number of initial transactions (Oracle storage parameter)  
15 MAX_TRANS OMAX_TRANS INT2 INT2 5   0   Maximum number of transactions (Oracle storage parameter)  
16 HEADER_MIN OHEADER_MI INT4 INT4 10   0   Block header, minimum size  
17 HEADER_MAX OHEADER_MA INT4 INT4 10   0   Block header, maximum size  
18 DATA_MIN ODATA_MIN INT4 INT4 10   0   Minimum size of the data area in a block  
19 DATA_MAX ODATA_MAX INT4 INT4 10   0   Maximum size of the data area in a block  
20 BLEVEL OBLEVEL INT4 INT4 10   0   Depth of the index from its root block to its leaf blocks  
21 LEAF_BLKS OLEAF_BLKS DEC11 DEC 11   0   Number of leaf blocks in the index  
22 DIST_KEYS ODIST_KEYS DEC11 DEC 11   0   Number of distinct indexed values  
23 L_BLKS_P_K OLBLKS_P_K DEC11 DEC 11   0   Avg. leaf blks per value of index key  
24 D_BLKS_P_K ODBLKS_P_K DEC11 DEC 11   0   Avg. data blocks per value of index  
25 CLU_FACTOR OCLU_FACTO DEC11 DEC 11   0   Amount of order of table rows based on index values  
History
Last changed by/on SAP  20130604 
SAP Release Created in