Re: Statspack and complete SQL statements - hash values
From: <Manimarann_at_gmail.com>
Date: 20 Jan 2006 00:09:08 -0800
Message-ID: <1137744548.667237.298580_at_g44g2000cwa.googlegroups.com>
Date: 20 Jan 2006 00:09:08 -0800
Message-ID: <1137744548.667237.298580_at_g44g2000cwa.googlegroups.com>
Use the v$sqltext_With_newlines table to extract the entire SQL
example:
select sql_text from v$sqltext_With_newlines
where hash_value = :sql_hash_value
order by piece
Received on Fri Jan 20 2006 - 09:09:08 CET