Re: How to find SQL statement in SQL area

From: Marin Dimitrov <marin.dimitrov_at_sirma.bg>
Date: Tue, 23 Oct 2001 05:50:29 -0700
Message-ID: <F001.003B20AC.20011023060018@fatcity.com>

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: marin.dimitrov_at_sirma.bg

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: ListGuru_at_fatcity.com (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). Received on Tue Oct 23 2001 - 07:50:29 CDT