Databases Reference
In-Depth Information
How it works...
In step 2 we query the
V$SYSTEM_EVENT
dynamic performance view for events related to
latches, and we obtain the following results:
We can see 29 waits on shared pool latches and a
TIME_WAITED
of 100.
In step 3 we create a test package and in step 4 we execute a workload procedure that
does not use bind variables. Before and after the execution we query the view as in step 2,
to compare the results obtained.