Logo

SQL Script

Monitor Cursors

 Tested on Oracle 8.1 Tested on Oracle 8.0 Tested on Oracle 7.3

Updated : 2-November-1998
Version : 1.0

Description

This script listsdetails of current open cursors.

Parameters

None.

SQL Source

set pages 0

col user_name form a9
col col1 form a9

select USER_NAME, to_char(sysdate,'hh24:mi:ss') col1, sql_text
from v$open_cursor;

set pages 200

select * from v$session_cursor_cache;
select * from v$system_cursor_cache;

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz
Legal

Logo