A typical use case for analyzing dynamic parameters is:
Disable statement cache:
set statement_cache off
Prepare the statement to be examined that contains the dynamic parameters.
Select @@plwpid to determine the object ID of the most recent lightweight procedure.
Run show_dynamic_params_in_xml using the value of @@plwpid as the value for object_id, and displaying the result in the local variable named xmldoc1.
Close the statement.
Enable the statement cache:
set statement_cache on
Analyze the results in xmldoc1, and select values for the parameters.
