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

Thread: Pinned Packages

  1. 12-10-2002, 01:08 AM #1
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    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.
    Reply With Quote Reply With Quote
  2. 12-10-2002, 02:39 AM #2
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 12-10-2002, 05:13 AM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    just use a startup trigger
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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