Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SHARED_POOL.UNKEEP
DBMS_SHARED_POOL.UNKEEP [message #35634] Tue, 02 October 2001 11:39 Go to next message
Andy Barrett
Messages: 4
Registered: October 2001
Junior Member
If I pin an object in the shared pool and then want to
unpin it using the ...UNKEEP option will this place the object on the LRU list or will it immediately discharge the object from the shared pool?

----------------------------------------------------------------------
Re: DBMS_SHARED_POOL.UNKEEP [message #35645 is a reply to message #35634] Wed, 03 October 2001 14:10 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I think I've read that it won't. You could check by setting sql_trace on, calling the object (I assume some code) and then check the trace file to see if parsing was required.

----------------------------------------------------------------------
Previous Topic: Procedure for creating a user
Next Topic: How to get return from out parameter of function
Goto Forum:
  


Current Time: Thu Mar 28 10:51:58 CDT 2024