Re: Any problems wth repeated pinning of a package?

From: Dana Stockler <dana.stockler_at_iname.com>
Date: 3 Nov 1998 06:27:54 GMT
Message-ID: <01be06f3$170118c0$b185a488@ws10>

| Oracle seems to use stack concept for memory usage. If there is anything
| not useful between the first and the second time you issue KEEP(). All
| these things are also pinned.

I'm sorry, but I don't understand what you're saying. Surely Oracle won't pin
things in memory without my telling it to? I haven't seen any evidence of this on my test machine (yet?).

| Therefore, Oracle recommends you should issue ALTER SYSTEM FLUSH SHARED
| POOL before you keep objects.

I haven't seen the recommendation that you flush the pool before pinning any
objects. If this is true, then it is a good reason for NOT scheduling a periodic
job to pin some packages (my original question) because of the performance hit caused by the flush. Can anyone out there confirm this?

Regards,
Dana Stockler Received on Tue Nov 03 1998 - 00:27:54 CST