SQL Script to Check the Open Cursors in the Oracle Database

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
SQL Query

set pages 1000 lines 120
col username for a15
SELECT 	OC.inst_id, 
		OC.user_name username,		OC.sid,
		OC.sql_text
FROM    gv$open_cursor OC
ORDER BY 2,3
/
advertisements
 
Output

   INST_ID USERNAME		       SID SQL_TEXT
---------- -------------------- ---------- ------------------------------------------------------------
	 1 SYS			       390 SELECT /*+ CONNECT_BY_FILTERING */ s.privilege# FROM sys.sys
	 1 SYS			       390 select name,intcol#,segcol#,type#,length,nvl(precision#,0),d
	 1 SYS			       390 select col#,intcol#,reftyp,stabid,expctoid from refcon$ wher
	 1 SYS			       390 select actionsize from trigger$ where obj# = :1
	 1 SYS			       390 select timestamp, flags from fixed_obj$ where obj#=:1

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer