Thanks everyone, for all your suggestions!!

-----Original Message-----
From: Ballurkar Ashutosh - Chantilly VA - Contractor
[mailto:oracledba-ezmlmshield-x2552764.[Email address protected]
Sent: Wednesday, June 02, 2004 5:05 PM
To: LazyDBA.com Discussion
Subject: RE: V$SQLAREA view only displays the first 80 character of sql
st atement


select sql_text
from v$sqltext st, v$session s
where s.sql_address = st.address and
s.sql_hash_value = st.hash_value and
s.sid=&sid
order by address, piece
/

Pass sid for the session and you will get the whole query.

Thanks, Ashu

-----Original Message-----
From: MacGregor Ian A.
[mailto:oracledba-ezmlmshield-x53221480.[Email address protected]
Sent: Wednesday, June 02, 2004 1:09 PM
To: LazyDBA.com Discussion
Subject: RE: V$SQLAREA view only displays the first 80 character of sql
st atement


V$sqltext has the entire "sql_text" in 64 byte chunks.

Ian MacGregor
Stanford Linear Accelerator Center
[Email address protected]

-----Original Message-----
From: Teffany Harris
To: LazyDBA.com Discussion
Sent: 6/2/2004 6:50 AM
Subject: V$SQLAREA view only displays the first 80 character of sql
statement

Hi all,
The V$SQLAREA view only displays the first eighty characters of the
SQL_TEXT
field is it possible to view the whole sql statement? If so what do I
need
to do?

Thanks



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page