Re: Reverse engineer SQL_TEXT from SQL_ID?

From: John Hurley <>
Date: Wed, 24 Feb 2010 06:12:43 -0800 (PST)
Message-ID: <>

On Feb 24, 8:10 am, Steve Howard <> wrote:


> 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