Not sure which version you are on, but V$SQLAREA on 9i stores 1000
characters, not 80. You may be referring to V$SQLTEXT which has a
64-character field, but this view shows the entire sql statement in 64-piece
chunks. I am reasonably sure the above is the case in 8i as well.

Cheers,

Vasan.

-----Original Message-----
From: Teffany Harris
[mailto:oracledba-ezmlmshield-x324263.[Email address protected]
Sent: 02 June 2004 14:51
To: LazyDBA.com Discussion
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

___________________________________________________________________________


This email and any attached to it are confidential and intended only for the
individual or entity to which it is addressed. If you are not the intended
recipient, please let us know by telephoning or emailing the sender. You
should also delete the email and any attachment from your systems and should
not copy the email or any attachment or disclose their content to any other
person or entity. The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you.

Churchill Insurance Group plc. Company Registration Number - 2280426.
England.

Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP.



Oracle LazyDBA home page