Get Live Help
The Total Parse Wait Time Ratio alarm is raised according to the proportion of time spent parsing SQL statements over the total active database time (not elapsed time).
When the alarm is raised it indicates a high level of parsing on the database, which may be causing latch contention on the shared pool and library cache latches. This may be due to excessive hard parsing of SQL statements that do not use bind variables. For more information on parse ratios, parse times, and on the SQL statements and sessions that may be triggering the alarm, see the SQL & Application Workload | Parse Activity Page.
A parse call is required to prepare a SQL statement for execution. Once parsed, a statement may be executed many times without the need for further parsing. If further parsing is needed, it may be either: