How to find SQL statement in SQL area

[Daiminger, Helmut]

Title: How to find SQL statement in SQL area

Hi!

How do I find the ENTIRE SQL statement that is dogging my box?

select sql_text from v$sqlarea where hash_value=123456

gives me the first part of the SQL statement; but since the statement is pretty long, the sql_text column does not contain the entire statement.

Is there a way to retrieve the entire statement? I also know the session ID of the application issuing the statement.

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut