24 lines
782 B
SQL
24 lines
782 B
SQL
-- -----------------------------------------------------------------------------------
|
|
-- File Name : https://oracle-base.com/dba/monitoring/sql_text_by_sid.sql
|
|
-- Author : Tim Hall
|
|
-- Description : Displays the SQL statement held for a specific SID.
|
|
-- Comments : The SID can be found by running session.sql or top_session.sql.
|
|
-- Requirements : Access to the V$ views.
|
|
-- Call Syntax : @sql_text_by_sid (sid)
|
|
-- Last Modified: 15/07/2000
|
|
-- -----------------------------------------------------------------------------------
|
|
SET LINESIZE 500
|
|
SET PAGESIZE 1000
|
|
SET VERIFY OFF
|
|
|
|
SELECT a.sql_text
|
|
FROM v$sqltext a,
|
|
v$session b
|
|
WHERE a.address = b.sql_address
|
|
AND a.hash_value = b.sql_hash_value
|
|
AND b.sid = &1
|
|
ORDER BY a.piece;
|
|
|
|
PROMPT
|
|
SET PAGESIZE 14
|