In v_$sqlarea the text is limited to 1000 characters. I'd like to see all of it, especially if it's over 1000 characters. Can I get that by putting together the pieces of GV$SQLTEXT? SQL> DESC GV$SQLTEXT Name Null? Type ----------------------------------------------------- -------- ------------------------------------ INST_ID NUMBER ADDRESS RAW(4) HASH_VALUE NUMBER COMMAND_TYPE NUMBER PIECE NUMBER SQL_TEXT VARCHAR2(64) SELECT PIECE, SQL_TEXT FROM GV$SQLTEXT WHERE ADDRESS = 'nnnnnnnn' ORDER BY PIECE ASC ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------