First page Back Continue Last page Graphics

Bind Variables Workshop

Bind Variables

Notes:

Workshop – Bind Variables
Trace the PL/SQL routine in the supplied script bind_variables_workshop.sql. Analyze the data for:
the number of hard parses
the number of soft parses
overall elapsed time
Modify the code to eliminate the unnecessary parses. Trace and reanalyze the data.