Regresar
-
Título
Spotlight query on v$latch is executed several times in the database. Why does Spotlight run this query? -
Descripción
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 -
Resolución
The Latch query is to fetch data for Oracle connection : Activity | Latches drilldown and Turning | Latch drilldown.