Re: Looking for suggestions - how find cause of sql invalidations
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Tue, 18 Jul 2017 11:29:37 -0500
Message-ID: <e36ef52140d39db4557c15fe5942f5db_at_society.servebeer.com>
Date: Tue, 18 Jul 2017 11:29:37 -0500
Message-ID: <e36ef52140d39db4557c15fe5942f5db_at_society.servebeer.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 18 2017 - 18:29:37 CEST