Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.10 - Release Notes

Parse Ratio Alarm

The Parse Ratio alarm is raised when the ratio of parse calls to execute calls exceeds a threshold. A parse call is required to prepare a SQL statement for execution. Once parsed, a statement can be executed many times. Excessive parsing wastes CPU and can cause latch contention.

Note: By default, the Parse Ratio alarm is disabled. It has been superseded (Oracle 10.2 and later) by the Total Parse Wait Time Ratio alarm. You may want to enable the Parse Ratio alarm when monitoring earlier versions of Oracle systems.

 

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation