Re: Reverse engineer SQL_TEXT from SQL_ID?
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 24 Feb 2010 10:16:37 -0800 (PST)
Message-ID: <3d509563-4138-4b06-8891-c8ce4d54b8a3_at_v25g2000yqk.googlegroups.com>
On Feb 24, 9:12 am, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> 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 )?
Date: Wed, 24 Feb 2010 10:16:37 -0800 (PST)
Message-ID: <3d509563-4138-4b06-8891-c8ce4d54b8a3_at_v25g2000yqk.googlegroups.com>
On Feb 24, 9:12 am, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> 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 )?
Yes, sorry I wasn't clear. That is what I meant by "live" views. Received on Wed Feb 24 2010 - 12:16:37 CST