Re: Looking for suggestions - how find cause of sql invalidations
- From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 18 Jul 2017 11:29:37 -0500
On 2017/07/18 10:37, Chris Taylor wrote:
DB: 12.1.0.2
OS: Red Hat Enterprise Linux Server release 6.8 (x86_64)
TL;DR: How to find cause of high sql invalidations when nothing obvious is
happening (such as stats or table ddl).
A good place to start is V$SQL_SHARED_CURSOR. See which columns are "Y"
for that SQL ID and go from there. Don't exclude the possibility of
bugs on those invalidations, either...
GL!
Rich
Other related posts: