Re: V$SQLTEXT text length

 You can use the "piece" fields, as in the following script:

select a.sid, a.username, s.sql_text
from v$session a, v$sqltext s

where    a.sql_address  = s.address
and      a.sql_hash_value = s.hash_value
order by a.username, a.sid, s.piece;

Hope This Helps,
Bill Gentry - DBA
Allina Health System
Mpls., MN
bgentryusa_at_lycos.com

--

On Wed, 12 Jun 2002 12:04:37  
 Jesse, Rich wrote:


>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).

>



_______________________________________________________
WIN a first class trip to Hawaii.  Live like the King of Rock and Roll
on the big Island. Enter Now!
http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Gentry
  INET: bgentryusa_at_lycos.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).