Re: Reverse engineer SQL_TEXT from SQL_ID?
Date: Wed, 24 Feb 2010 06:12:43 -0800 (PST)
On Feb 24, 8:10 am, Steve Howard <stevedhow..._at_gmail.com> 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