Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to find SQL statement in SQL area

How to find SQL statement in SQL area

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Tue, 23 Oct 2001 03:54:24 -0700
Message-ID: <F001.003B1FE4.20011023034017@fatcity.com> 









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




Received on Tue Oct 23 2001 - 05:54:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US