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

Thread: Pinned Packages

  1. #1
    Join Date
    Dec 2001
    Baltimore, MD

    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
    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
    Brisbane, Queensland, Australia

    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.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jun 2000
    Madrid, Spain
    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