Re: SQL_text

From: Gennadiy Greenberg <gennadiy.greenberg_at_siemens.com.ua>
Date: Tue, 21 Mar 2000 15:32:44 +0200
Message-ID: <38D779FB.CFDEAC4B@siemens.com.ua>

boris wrote:

> How can I view the text of the query wich has been executed if the size of
> this text is bigger than 1000 bytes?
> thanks in advance.

You can query:

select st.sql_text
from v$sqlarea sa, v$sqltext st
where sa.hash_value = st.hash_value
order by st.hash_value, st.piece;

---

Gennadiy Greenberg
Oracle DBA Received on Tue Mar 21 2000 - 07:32:44 CST