Re: tracking down hidden SQL???

From: Adric Norris <>
Date: Wed, 16 Oct 2013 13:58:12 -0500
Message-ID: <>

On Wed, Oct 16, 2013 at 1:51 PM, Chris Taylor <> 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';



Received on Wed Oct 16 2013 - 20:58:12 CEST

Original text of this message