- SELECT SUM(w.p3) Sleeps
- FROM V$SESSION_WAIT w, V$LATCHNAME n
- WHERE w.event = 'latch free'
- AND w.p2 = n.latch#
- GROUP BY n.name
The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
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