Re: v$sql - executions vs loads vs invalidations

From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Tue, 1 May 2012 07:04:37 -0400
Message-ID: <CAGzKQQcQXJ9Xs0VFoaH2tzRiw03bgYPNPhL+FHh_Wo-ZOSGKEA_at_mail.gmail.com>



Gerry,
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]*
>
> Regards
> GregG
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 01 2012 - 06:04:37 CDT

Original text of this message