Re: AWR not capturing sql_id anymore

  • From: Stojan Veselinovski <stojan.veselinovski@xxxxxxxxx>
  • To: rjamya <rjamya@xxxxxxxxx>
  • Date: Fri, 8 Feb 2013 14:39:03 +1100

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:

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

Stojan.
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2013