-
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.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
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?
I'm stmontgo and I approve of this message
-
whence_invalidations.sql
May be able to help you out.
http://www.ixora.com.au/scripts/library.htm
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|