-
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