Re: AWR not capturing sql_id anymore

From: Stojan Veselinovski <stojan.veselinovski_at_gmail.com>
Date: Fri, 8 Feb 2013 14:39:03 +1100
Message-ID: <CALn1tDsDavsz8um1SHPWJ2NE=yzTE1f4LZ1_xrx2o_=Npru=dQ_at_mail.gmail.com>



A little workaround fix - flush the sql_id from the shared pool and now it's being picked up again and populated in dba_hist_sqlstat.

I've also just come across an old thread with the same issue:

http://www.freelists.org/post/oracle-l/Missing-SQL-in-DBA-HIST-SQLSTAT

Stojan.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 08 2013 - 04:39:03 CET

Original text of this message