long varchar

[pando]

does anyone know how to see the whole line of sql_text in v$open_cursor?

[akkerend]

Use columns ADDRESS and HASH_VALUE to find SQL_TEXT in v$SQLTEXT, order by PIECE.

[pando]

err I want to query v$open_cursor though

[omegamark]

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

[steeve123]

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: Steeve_2@videotron.ca

[akkerend]

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