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.
About parsing
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:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center