SAP ABAP Table SYB_VIEW_STMTCACHEUSAGE_DTL (SYB: View data structure for Statement Cache Usage (Detail))
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor
Basic Data
Table Category INTTAB    Structure 
Structure SYB_VIEW_STMTCACHEUSAGE_DTL   Table Relationship Diagram
Short Description SYB: View data structure for Statement Cache Usage (Detail)    
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 STMTCACHEUSAGE SYBMON_STMTCACHEUSAGE   STRU 0   0    
2 INSTANCEID SYBINSTID   INT2 5   0   SYB: Instance ID in Cluster Edition  
3 TOTALSIZEKB     INT4 10   0    
4 USEDSIZEKB     INT4 10   0    
5 NUMSTATEMENTS     INT4 10   0    
6 NUMSEARCHES SYBBIGINT   DEC 22   0   SYB: Big Integer  
7 HITCOUNT SYBBIGINT   DEC 22   0   SYB: Big Integer  
8 NUMINSERTS SYBBIGINT   DEC 22   0   SYB: Big Integer  
9 NUMREMOVALS SYBBIGINT   DEC 22   0   SYB: Big Integer  
10 NUMRECOMPILESSCHEMACHG SYBBIGINT   DEC 22   0   SYB: Big Integer  
11 NUMRECOMPILESPLANFLUSHES SYBBIGINT   DEC 22   0   SYB: Big Integer  
12 SOURCE_HOSTNAME SYBHOSTNAME SYBHOSTNAME CHAR 128   0   SYB: Hostname  
13 SNAPSHOT_TIMESTAMP DB6TSTAMP   CHAR 14   0   DB6: Timestamp (Format: YYYYMMDDHHMMSS)  
14 TIMESTAMP_FROM DBAFTTSTAMP   STRG 0   0   DBA Formatted Timestamp  
15 TIMESTAMP_TO DBAFTTSTAMP   STRG 0   0   DBA Formatted Timestamp  
16 TIME_PERIOD     INT4 10   0    
17 HITRATIO     DEC 6   2    
18 DETAILS SYBMON_STMTCACHEUSAGE_TAB   TTYP 0   0    
History
Last changed by/on SAP  20140117 
SAP Release Created in 731