Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
set echo off
-- oc.sql
-- Purpose: Display open cursor information.
-- -----------------------------------------------------------------------------
column username format a25
column program format a35
column sid format 999999
SELECT s.sid,s.username,s.program,count(oc.sid) open_cursors
FROM v$session s, v$open_cursor oc
WHERE oc.sid = s.sid
GROUP BY s.sid,s.username,s.program
ORDER BY open_cursors desc
/
set echo on