Databases Reference
In-Depth Information
There's more...
In previous recipes we have seen that not using bind variables led to performance and
scalability problems, not sharing SQL statements.
In this recipe we have also seen that when we don't use bind variables, there are latch
contentions on the library cache. We can see this behavior by inspecting the
V$SYSTEM_EVENT
dynamic performance view.
As stated in previous recipes, we don't tune latch contention, but the presence of these
types of issues in the database is an alert signal that something else is wrong and it needs
to be tuned.
See also
F
Chapter
4
,
Using
bind
variables
F
Tuning
latches
in this chapter
F
Tuning
resources
to
minimize
latch
contention
in this chapter