-
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
Radhakrishnan.M
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|