Re: tracking down hidden SQL???
From: Adric Norris <landstander668_at_gmail.com>
Date: Wed, 16 Oct 2013 13:58:12 -0500
Message-ID: <CAJueESqGs7XSyBcfk8m=yynL6n0BPdrYSM2Nwq6++-re8DUj4w_at_mail.gmail.com>
On Wed, Oct 16, 2013 at 1:51 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:
> You could check DBA_HIST_SQLSTAT which is a running collection of SQL
> statement stats (just to see if it ever got captured). If so, from there
> you could grab the force_matching_signature and find any SQLs that share
> the same execution plan. Doubtful its in there, but worth a look.
>
Date: Wed, 16 Oct 2013 13:58:12 -0500
Message-ID: <CAJueESqGs7XSyBcfk8m=yynL6n0BPdrYSM2Nwq6++-re8DUj4w_at_mail.gmail.com>
On Wed, Oct 16, 2013 at 1:51 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:
> You could check DBA_HIST_SQLSTAT which is a running collection of SQL
> statement stats (just to see if it ever got captured). If so, from there
> you could grab the force_matching_signature and find any SQLs that share
> the same execution plan. Doubtful its in there, but worth a look.
>
Unfortunately, the SQL_ID in question isn't present. It was an excellent suggestion, however.
SQL> select count(*) from dba_hist_sqlstat 2 where sql_id = '0p8ucmfzpm28r';
COUNT(*)
0
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 16 2013 - 20:58:12 CEST