DBMS_SHARED_POOL.KEEP [message #231339] |
Mon, 16 April 2007 10:49 |
faiz_hyd
Messages: 294 Registered: February 2006
|
Senior Member |
|
|
Hi,
Was thinking of utilizing this feature to pin some of the Frequently called Packages and other Code DBMS_SHARED_POOL.KEEP .
I couldn't find some details on this utility in documentation, so few questions on this
When we pinned some code which has parameter values, will it get refreshed when we call it again for some other task, or will it keep in buffer the parameter value of the first call.
Second thing when we drop and recreate the Package or code do we have execute this again DBMS_SHARED_POOL.KEEP so as to get the latest code.
oracle Version is 9.2
regards
[Updated on: Mon, 16 April 2007 12:46] Report message to a moderator
|
|
|
|
Re: DBMS_SHARED_POOL.KEEP [message #231352 is a reply to message #231339] |
Mon, 16 April 2007 12:41 |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
Just curious, but I have been operating under the assumption that pinning code just isn't something needed / worth it anymore (by anymore I mean specifically 10g onwards). There are pretty much always better and more effective things to do with available time.
Does anyone have any specific 10g examples / situations in which you have gone to the trouble and it been worth it?
|
|
|