How to find SQL statement in SQL area
try this:
select t.sql_text,
t.piece,
a.hash_value
from v$sqltext t,
v$sqlarea a,
v$session s
where s.sql_address=t.address
and s.sql_address=a.address
order by a.address, t.piece
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
----- Original Message -----
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, October 23, 2001 14:40
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Marin Dimitrov
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
