Lot of invalidations in sql area
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Lot of invalidations in sql area

  1. #1
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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.

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    is your app using bind variables? lots of ad hoc queries?
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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.

  6. #6
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  7. #7
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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
  •  



Click Here to Expand Forum to Full Width