select sql_text from v$sqltext
order by hash_value,piece

will do.

Thanks

Sakthi.

Sakthivel Govindasamy
Database Administration
ACS - Global Human Resources Solutions
Email: Sakthivel.[Email address protected]
[Email address protected]
Phone: +353 21 4511395



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

Oracle LazyDBA home page