Re: Reverse engineer SQL_TEXT from SQL_ID?
Date: Wed, 24 Feb 2010 05:10:19 -0800 (PST)
Message-ID: <52877727-b20b-4524-97b9-8894be95c218_at_b2g2000yqi.googlegroups.com>
On Feb 23, 12:12 pm, joel garry <joel-ga..._at_home.com> 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
> --
> _at_home.com is bogus.http://www.signonsandiego.com/news/2010/feb/23/ucsd-media-outlets-see...
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.
Thanks,
Steve Received on Wed Feb 24 2010 - 07:10:19 CST