MIB Viewer
MIB Viewer Desktop New

oramodMetricsUCPP

OBJECT-TYPE
1.3.6.1.4.1.546.16.4.11.2.1.1.18
Access
read-only
Status
mandatory
Sub-identifiers
0
User Calls Per Parse Ratio scaled by 100. The ratio of user calls to parse in the shared SQL area. Indicates how well the application is managing its context area. If it changes, then application change is the most likely explanation, but it may indicate the useage patterns are changing and users are moving from one module to another either more frequently or less frequently. Although the shared SQL area makes the maximizing of this ratio less important than with earlier versions of Oracle, it is still possible to reduce resource usage by raising this ratio.
Gauge