MIB Viewer

oramodExpSqlPARSECNT

OBJECT-TYPE
1.3.6.1.4.1.546.16.4.11.7.1.1.5
Access
read-only
Status
mandatory
Sub-identifiers
0
Number of Parses. Parsing is the work done by the database to validate the SQL statement and generate the query plan used for execution. When the parse count is close to that of executions for a given statement, you may be continually reparsing that statement. You can reduce parsing by making sure that statements are reused as much as possible in the shared pool. In general, a large number of hard parses indicates that more memory is needed for the shared pool.
Gauge