The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
Latch
By Guest on 15th March 2019 12:57:19 PM | Syntax: TEXT | Views: 1



New paste | Download | Show/Hide line no. | Copy text to clipboard
  1. SELECT SUM(w.p3) Sleeps
  2.   FROM V$SESSION_WAIT w, V$LATCHNAME n
  3.  WHERE w.event = 'latch free'
  4.    AND w.p2 = n.latch#
  5.  GROUP BY n.name



  • Recent Pastes