SQL Script Monitor Cursors

Updated: 02-Nov-1998
Version: 1.0

Description

This script listsdetails of current open cursors.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

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

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links