Re: Reverse engineer SQL_TEXT from SQL_ID?

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Wed, 24 Feb 2010 06:12:43 -0800 (PST)
Message-ID: <d2e3110c-ed27-4d23-ab26-40545a673f45_at_a18g2000yqc.googlegroups.com>



On Feb 24, 8:10 am, Steve Howard <stevedhow..._at_gmail.com> wrote:

snip

> That is what is odd.  I couldn't find it anywhere, in any of the live
> views, DBA_HIST views, GRID, etc.  An ASH report said "SQL
> unavailable", but yet it had the SQL_ID.  The only time I have ever
> seen this is when it was DDL , but nothing shows up as having been
> changed during or since that time period.
>
> It was executed several times over a 35 minute period (I noticed it
> after the fact in a daily health check), yet no SQL was recorded.

Did you look in the v$ views ( v$sqlarea or v$sql etc )? Received on Wed Feb 24 2010 - 08:12:43 CST

Original text of this message