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 [EMAIL PROTECTED] -- 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 >[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jesse, Rich > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
