Pinned Packages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Pinned Packages

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Pinned Packages

    Hi All,
    I pinned some packages and cache few frequently used tables.
    At the startup the tables remained still chached, however I had to re pin the packages all over again.
    Is there any script or trigger that will automatically pin the packages at the database startup?
    Please advise
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203

    Re: Pinned Packages

    Originally posted by Ablakios
    Hi All,
    At the startup the tables remained still chached,
    Yeah the tables are created with a CACHE/NOCACH option.. it doesn't mean they are CACHED in momory, it just means in a FTS they are read into the MRU end of the Buffer Cache. As for pinning packages, I'm thinking you didn't try the SEARCH functionality on this forum. Cause i just tried "Pinning Startup" and found the following... enjoy.

    http://www.dbasupport.com/forums/sho...inning+startup
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    just use a startup trigger

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