障害調査
ちらしの裏。
■オープンカーソルの情報
SELECT
SID, OSUSER, MACHINE, PROGRAM, USERNAME,SQL_TEXT
FROM
V$OPEN_CURSOR JOIN V$SESSION USING (SID)
WHERE
USERNAME IN ('hoge');
■セッションの情報
参考:*1
SET LINES 120;
SET FEED ON;
COL SID FORMAT 990;
COL USERNAME FORMAT A10;
COL STATUS FORMAT A10;
COL MACHINE FORMAT A10;
COL PROGRAM FORMAT A50;
SELECT SID,SERIAL#,
USERNAME,
STATUS,
MACHINE,
PROGRAM ||
DECODE(AUDSID,USERENV('SESSIONID'),' <= THIS SESSION',NULL) AS
PROGRAM
FROM SYS.V_$SESSION
WHERE USERNAME IS NOT NULL
ORDER BY USERNAME,DECODE(AUDSID,USERENV('SESSIONID'),1,0),SID