This view shows the effectiveness of the procedure cache of Adaptive Server since the start of the session. It shows the:
Percentage of requests for stored procedure executions that were satisfied by the procedure cache
Number of logical reads and physical reads of stored procedures since the start of the session
Overall rate of logical and physical reads of stored procedures since the start of the session
SMC_SIZET session_procedure_cache_stats_count = 5;
SMC_DATAITEM_STRUCT session_procedure_cache_stats_view[] = {
{ SMC_NAME_STP_HIT_PCT, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_STP_LOGICAL_READ,, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_STP_LOGICAL_READ, SMC_STAT_RATE_SESSION },
{ SMC_NAME_STP_PHYSICAL_READ, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_STP_PHYSICAL_READ, SMC_STAT_RATE_SESSION }
};
