Home -> Mailing Lists -> Oracle-L -> SQL Profile Expired?

SQL Profile Expired?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 26 May 2017 14:13:09 -0500
Message-ID: <CAJvnOJZDgCML8tNn2V3x3Pjc30xS32Ghmma08LB2453_-_J+KA_at_mail.gmail.com> 





As we all know, sql profiles can become invalid if the stats on a table
change, or the layout of a table changes.  Has anyone found a way to
identify when a profile is no longer valid, without actually running the
query in question?



I would like to run a daily report to identify any sql profiles that have
become invalid. Sometimes an application provider will implement a change
and a large query that we had fixed suddenly goes crazy again.


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l


Received on Fri May 26 2017 - 21:13:09 CEST












Original text of this message