Re: How to get rid of invalidated V$sql entries

From: Alfonso León <aleon68_at_gmail.com>
Date: Wed, 23 Feb 2005 16:33:26 -0500
Message-ID: <83a585ac050223133319d7fd21@mail.gmail.com>

Thanks for your answer Stephane:

I Think they're not parents at all, it is the same instrucction, same program,same schema, and they're dead, and I guess they still sharable memory and cpu every time the same instruction comes to execute again, because it will be compared with the actual cursors.

Alfonso

On Wed, 23 Feb 2005 22:23:38 +0100, Stephane Faroult <sfaroult_at_roughsea.com> wrote:
> Alfonso,

>=20

> When the same text (ie the same hash value) appears different times
> but with different execution plans (either because the same table names
> correspond to different tables - same name, different schema, or private
> synonyms aliasing different objects - or because session-level
> parameters such as sort_area_size or optimizer_goal are different and
> lead to a different execution plan) there is one 'parent' cursor with 0
> executions and several child cursors with different child-num but same
> sql_address/hash_value. You can't get rid of parents .... Just ignore
> whatever seems not to be executed.

>=20

> HTH

>=20

> Stephane Faroult

>=20

> Alfonso Le=F3n wrote:

>=20


> >Hello:

> >

> >I have some questions:

> >

> >1. We have a java tool that makes queries to the Databas (9.2.0.6).

> >When I check in the v$sql view at 5pm I can see there are entries

> >since 8:30 in the morning, with 0 executions and other fields, I guess
> >they=3DB4re invalidated or just old, but when would the dissapear? Ther =
is
> >a way to get rid of that entries.
> >
> >2. Oracle says that V$sqlarea is an aggregate of V$sql but when I do a
> >sum of the sharable_mem of the active entries of a hash_value the
> >result is different of the sharable_mem of the V$sqlarea.
> >
> >I will appreciate your ideas.
> >
> >--=3D20
> >Alfonso Leon
> >--
> >http://www.freelists.org/webpage/oracle-l
> >
> >
> >

>=20
>=20

--=20
Alfonso Leon

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

Received on Wed Feb 23 2005 - 16:37:24 CST