Does anyone know how to get the full sql statement from the sql_text column of v$sqlarea. The column type is varchar2(1000) but the documentation says it will only show 80 characters.

Any help would be much appreciated.