Re: v$sql - executions vs loads vs invalidations
Date: Tue, 1 May 2012 07:04:37 -0400
I offer to perform a quick review of your issue. Please get me SQLT XTRACT for one representative SQL (MOS 215187.1). Among other things, SQLT would show WHY cursor sharing is not happening (based on gv$sql_shared_cursor). It will also show timestamp of DDL commands affecting the objects behind the SQL.
Cheers -- Carlos
On Tue, May 1, 2012 at 6:53 AM, GG <grzegorzof_at_interia.pl> wrote:
> W dniu 2012-05-01 11:41, Gerry Miller pisze:
> >LOADS: 2794
> >INVALIDATIONS: 2793
> >EXECUTIONS: 0
> You've never mentioned DB version :) but basically looks like
> statements are only parsed and never executed (application issue ?).
> You got invalidation because some dependent objects are 'manipulated' via
> (grants, ddls, stats gathering and so) ,
> loads are because of flushes which could be caused by shared pool free
> space pressure .
> For better understanding we need some info about sga size and allocations
> and ora-4031 related dumps .
> Meantime You can check
> *Master Note for Diagnosing ORA-4031 [ID 1088239.1]*