Re: v$sql - executions vs loads vs invalidations
From: GG <grzegorzof_at_interia.pl>
Date: Tue, 01 May 2012 12:53:00 +0200
Message-ID: <4F9FC08C.8050101_at_interia.pl>
W dniu 2012-05-01 11:41, Gerry Miller pisze:
Date: Tue, 01 May 2012 12:53:00 +0200
Message-ID: <4F9FC08C.8050101_at_interia.pl>
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-lReceived on Tue May 01 2012 - 05:53:00 CDT