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: 4



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
  • NetlfiyCMS
    1 hour 49 mins 16 secs ago
  • Encript
    2 hours 7 mins 31 secs ago
  • The Plane Crash
    2 hours 37 mins 45 secs ago
  • Tg
    4 hours 12 mins 16 secs ago
  • Mm
    4 hours 13 mins 13 secs ago