Return
-
Title
Spotlight query on v$latch is executed several times in the database. Why does Spotlight run this query? -
Description
It is noticed that the Spotlight Query below is run a lot of times on the server. What is this query for?SELECT l.latch#,
l.gets,
l.misses,
l.sleeps,
l.immediate_gets,
l.spin_gets,
COUNT ( * ) n_latches
FROM v$latch l, v$latch_children lc
WHERE l.latch# = lc.latch#(+) AND l.gets > 0
GROUP BY l.latch#,
l.gets,
l.misses,
l.sleeps,
l.immediate_gets,
l.spin_gets
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.