Lot of invalidations in sql area

Hi,

Info:

DB: 8.1.7.4
OS: Sun Solaris 2.6

I executed next query in this DB:

SELECT NAMESPACE,PINS,RELOADS,INVALIDATIONS
FROM V$LIBRARYCACHE;

And this is the result:

NAMESPACE PINS RELOADS INVALIDATIONS
--------------- ---------- ---------- -------------
SQL AREA 281461 238 730
TABLE/PROCEDURE 21338 0 0
BODY 657 0 0
TRIGGER 0 0 0
INDEX 115 0 0
CLUSTER 1385 0 0
OBJECT 0 0 0
PIPE 0 0 0

Does someone know what is the meaning of this 730 invalidations in sql area and how could I solve?

Thanks in advance

Angel

Invalidations occur when when an object referenced in an sql statement is modified in any way, so the statement must be reparsed.

Yes I know sureshy. But it is taking during load processing of nettracker tool, that as developer said us, only insert,delete, update on tables.

Any idea?

Cheers

Angel

is your app using bind variables? lots of ad hoc queries?

whence_invalidations.sql

May be able to help you out.

http://www.ixora.com.au/scripts/library.htm

Stmontgo: Yes as the developers know. Nettracker as they said me is a closed tool.

Sureshy: Thank you for the link. I will say you anything.

Cheers

Angel

There were no luck, the executions said no files where modified.

More ideas?

Cheers

Angel