does anyone know how to see the whole line of sql_text in v$open_cursor?
Printable View
does anyone know how to see the whole line of sql_text in v$open_cursor?
Use columns ADDRESS and HASH_VALUE to find SQL_TEXT in v$SQLTEXT, order by PIECE.
err I want to query v$open_cursor though
SQL>desc v$open_cursor
Name Null? Type
------------------------------- -------- ----
SADDR RAW(4)
SID NUMBER
USER_NAME VARCHAR2(30)
ADDRESS RAW(4)
HASH_VALUE NUMBER
SQL_TEXT VARCHAR2(60)
hope now you can understand
Heres a select to see the entire line of the sql statement:
you can add a where with the table v$session to find select for a specific session with the field SADDR equal to v$sqlarea.address.
select a.disk_reads,B.SQL_TEXT
from v$sqlarea a,v$sqltext B
where A.ADDRESS = B.ADDRESS
order by A.disk_reads desc, b.piece;
Steeve Bisson
EMail: [email protected]
select ocr.sid, ocr.address, stt.sql_text
from v$open_cursor ocr, v$sqltext stt
where ocr.address = stt.address
and ocr.hash_value = stt.hash_value
order by ocr.sid, ocr.address, stt.piece