Re: sqlarea

From: Steve Jelfs <steve_at_trolltec.co.uk>
Date: Thu, 29 Jul 2004 16:17:39 +0100
Message-ID: <WorldClient-F200407291617.AA17390007@trolltec.co.uk>

Don't you need
v$sqltext_with_newlines
?
Cheers

Steve

--    

-----Original Message-----
From: Thomas Day <tday6_at_csc.com>
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 29 2004 - 10:13:43 CDT