All MIBs › EMPIRE-ORAMOD › oramodExpSqlPARSECNT
oramodExpSqlPARSECNT
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodExpSqlPARSECNT
OID (numeric): 1.3.6.1.4.1.546.16.4.11.7.1.1.5
Node type: OBJECT-TYPE
Type: Gauge
Access: read-only
Description: 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.
What is oramodExpSqlPARSECNT?
The number of times this specific SQL statement has been parsed. The description explains that a parse count close to the execution count means the statement is being continually reparsed rather than reused, and recommends ensuring statements are reused in the shared pool to reduce this.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.7.1.1.5 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodExpSqlPARSECNT
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.7.1.1.5.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodExpSqlPARSECNT.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> oramodExpSqlPARSECNT.1
Start monitoring Server running Oracle database, monitored by CA/Empire SystemEDGE agent with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the EMPIRE-ORAMOD::oramodExpSqlPARSECNT OID value, configure state conditions and alerts, and monitor any Server running Oracle database, monitored by CA/Empire SystemEDGE agent from a single console.
OID Breakdown
Upper-level ancestors (8 from the standard OID tree / other modules)
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | AirPair-MIB |
| 1.3.6 | dod | AirPair-MIB |
| 1.3.6.1 | internet | AirPair-MIB |
| 1.3.6.1.4 | private | AirPair-MIB |
| 1.3.6.1.4.1 | enterprises | AirPair-MIB |
| 1.3.6.1.4.1.546 | empire | CAHYPERV-AIM-MIB |
| 1.3.6.1.4.1.546.16 | applications | CAHYPERV-AIM-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.546.16.4 | oracledb | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11 | oramodPerf | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7 | oramodExpSql | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7.1 | oramodExpSqlTable | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7.1.1 | oramodExpSqlEntry | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.5 | oramodExpSqlPARSECNT | EMPIRE-ORAMOD |