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?
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
Re: Pinned Packages
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.
Originally posted by Ablakios
At the startup the tables remained still chached,
OCP 8i, 9i DBA
just use a startup trigger
Click Here to Expand Forum to Full Width