Oracle-L: RE: V$SQLTEXT text length

From: Rodrigues, Bryan <BRodrigues_at_elcom.com>
Date: Wed, 12 Jun 2002 16:48:22 -0800
Message-ID: <F001.0047C937.20020612164822@fatcity.com>

Jesse,

You could access the v$sqltext. It contains the whole query in 64 character sections. it is not as organized as sql_text in v$sqlarea, but if you put all the rows with sql_text field ordered by piece column you will have the full query.

Bryan Rodrigues

-----Original Message-----
Sent: Wednesday, June 12, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L

While researching some shared_pool problems <groan> on an 8.1.6 instance, I happen to notice that the SQL_TEXT column of the V$SQLAREA view is "only" 1000 bytes. What happens when the statement is longer than that? Does it just not show all of it in that view?

Just curious.

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rodrigues, Bryan
INET: BRodrigues_at_elcom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------