Re: v$sql - executions vs loads vs invalidations

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Tue, 1 May 2012 23:33:21 +0530
Message-ID: <CAJsOtB6j3ZMYxOjAhSMYz_G3e45jFaYkXpcYB09VdFSD9_iy9Q_at_mail.gmail.com>

is this is a linux..rhel 4.x
what is the front end application..oracle forms... there is one parameter with which you can increase the size of generated trc files and make sure that there not too many audit programs running..and then start drilling down..
thanks..subodh

On 1 May 2012 18:07, Gerry Miller <gerry_at_millerandbowman.com> wrote:

> Hi GG
>
> These cursors don't have a high version count; there is only one of
> each, but it has been loaded thousands of times.
>
> I just had a look at Tanel's script and I have already run some queries
> against X$KSMSS , which suggested that the problem is with subpool 2
> (out of 4). I then ran this query:
> SELECT KGHLUSHRPOOL "SUBPOOL", KGHLURCR "PINS AND|RELEASES",
> KGHLUTRN, KGHLUFSH, KGHLUOPS,
> KGHLUNFU "ORA-4031|ERRORS", KGHLUNFS "LAST ERROR|SIZE"
> FROM SYS.X$KGHLU
>
> and it said that ALL of the ORA_04031 errors occurred in subpool 2.
> Until then I was sceptical about subpool imbalance being the cause but
> now I am not so sure.
>
> Thanks for your help on this.
>
> Gerry
>
>
> GG wrote:
> > Good , You've got MOS access ,so
> > follow *Troubleshooting: High Version Count Issues [ID 296377.1]
> >
> > and then **Script - Determine reason for high Child Cursor Count -
> > V$SQL_SHARED_CURSOR [ID 1422573.1] .
> >
> > And I recommend following Carlos Sierra advice related to '*SQLT
> > XTRACT' as he is the Author :) that neat tool .
> > I had bad experience with cursor sharing similar but looks like FORCE
> > could cause troubles as well (unsafe binds).
> > Speaking about shared pool imbalance You can use Tanel script:
> >
> >
> --------------------------------------------------------------------------------
> >
> > --
> > -- File name: sgastatx
> > -- Purpose: Show shared pool stats by sub-pool from X$KSMSS
> > --
> > -- Author: Tanel Poder
> > -- Copyright: (c) http://www.tanelpoder.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=============================================
Love me or Hate me both are in my Favour.
Love me, I am in your Heart. Hate me, I am in your Mind.
=============================================


--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 01 2012 - 13:03:21 CDT