agree with you Pando. Poster can use sql_fulltext instead of sql_text even from v$sql.

Mcslain - you can get the complete sql from v$sql.sql_fulltext or v$sqltext.sql_text (order by piece) or from v$sqlstats.sql_fulltext. Advantage with v$sqlstats is you can find the SQL even after the cursor aged out of shared pool.

SQL> set long 50000
SQL> set line 100
SQL> select sql_fulltext from v$sql where hash_value=xxxxxxxxxx; or
SQL> select sql_text from v$sqltext where hash_value=xxxxxxxx order by piece; or
SQL> select sql_fulltext from v$sqlstats where plan_hash_value=xxxxxxxxxx;

Thanks,