Re: sqlarea
- From: "Steve Jelfs" <steve@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Jul 2004 16:17:39 +0100
Don't you need
v$sqltext_with_newlines
?
Cheers
Steve
--
-----Original Message-----
From: Thomas Day <tday6@xxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 29 Jul 2004 10:32:37 -0400
Subject: sqlarea
>
> 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
-----------------------------------------------------------------
Other related posts:
