Re: Reverse engineer SQL_TEXT from SQL_ID?

From: Steve Howard <>
Date: Wed, 24 Feb 2010 05:10:19 -0800 (PST)
Message-ID: <>

On Feb 23, 12:12 pm, joel garry <> wrote:
> select count(*) from (
> select sql_id from dba_hist_sqltext
> where sql_id not in (select distinct sql_id from dba_hist_sqlstat)
> )
> /

> I think AWR has some way to output html links to sql stuff too,
> google.  But of course, you are probably already doing the same thing.
> jg
> --
> is bogus.

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.


Steve Received on Wed Feb 24 2010 - 07:10:19 CST

Original text of this message