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

Home -> Community -> Mailing Lists -> Oracle-L -> FULL SQL Query Code in Statspack report

FULL SQL Query Code in Statspack report

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 24 May 2004 22:05:16 +0530
Message-ID: <F0CB3C9983B77E4AB4ADEFA63DAB109F0711456E@twrmsg03.ad.infosys.com> 





Folks



Is it possible to enable some parameter for getting the FULL SQL Query
Code in the Statspack report?



OR Does the respective HASH_VALUE of the incomplete SQL Query (from
Statspack) need to be manually searched in V$SQLTEXT for getting the
Complete Code?



Thanks






Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Received on Mon May 24 2004 - 11:31:55 CDT












Original text of this message













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