Statement Worst Preparation Time



Snapshot Level
Dynamic SQL


Logical Data Grouping
dynsql


Monitor Switch
Basic


Resettable


No


 


Element Name
Element Type



prep_time_worst
water mark

 

Description:  The longest amount of time in microseconds that was required to prepare a specific SQL statement.

Usage:  Use this value in conjunction with "Statement Best Preparation Time" to identify SQL statements that are expensive to compile.