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
Debe iniciar sesión
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.