Re: Pinning packages

Hi Peter....

First, and just to be pedantic, it's called 'keeping' packages, not 'pinning' (though since everyone and his dog uses the incorrect term, I guess I'm just fighting a losing battle)...

Second, what you want is the dbms_shared_pool package, the 'keep' procedure within that package, and a startup trigger.

The trigger will go something like this:

Create trigger Keepme
After startup on database
dbms_shared_pool.keep('Schema.Packagename');

(And you just repeat the dbms_shared_pool.keep line as often as you need to for each new package).

I have a version of this that works on the Performance Tuning course, but I don't have it to hand right now -and I can't remember if there are 'is begin' and 'end's in that package, but the above is the general gist (sometime, I must learn PL/SQL properly!).

Hope it gets you close, anyway, and that you now know what sort of stuff to search for in the documentation etc.

Regards
HJR <peter.mckenzie_at_health.wa.gov.au> wrote in message news:9i3ai8$nlc$1_at_news.netmar.com...
> How do I automatically pin packages at/after instance startup ?
> Thanks.
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
 eb -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
 groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net Received on Sun Jul 08 2001 - 06:36:40 CDT