Database Control / DBSNMP Parse Errors
I've been investigating the cause of some high "parse failure" counts in an AWR report and found that the culprit seems to be DB Control.
| Statistic | Total | per Second | per Trans |
|---|
| parse count (failures) | 45,828 | 50.82 | 4.69 |
| parse count (hard) | 47,586 | 52.77 | 4.87 |
Looking at V$SESS_TIME_MODEL, the sessions with the highest stat_name = 'failed parse elapsed time' are DBSNMP and SYSMAN.
I read through 1353015.1 (How to Identify Hard Parse Failures) and turned on the 10035 trace, and have found it appears to be caused by this query:
Tue Jan 27 10:44:25 2015 PARSE ERROR: ospid=65521, error=936 for statement: select msgid from WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_I where SUBSCRIBER# = and rownum <=1
1