| UNKEEP |
| Unpin an object from memory |
dbms_shared_pool.unkeep(name IN VARCHAR2, flag IN CHAR DEFAULT 'P'); |
| exec dbms_shared_pool.unkeep('UWCLASS.TESTPROC', 'P'); |
| |
| UNMARKHOT |
Unmark a library cache object as a hot object
Overload 1 |
dbms_shared_pool.unmarkhot(
schema IN VARCHAR2,
objname IN VARCHAR2,
namespace IN NUMBER DEFAULT 1,
global IN BOOLEAN DEFAULT TRUE); |
| TBD |
| Overload 2 |
dbms_shared_pool.unmarkhot(
hash IN VARHAR2,
namespace IN NUMBER DEFAULT 1,
global IN BOOLEAN DEFAULT TRUE); |
| TBD |
| |
| Related Query |
| To find information on pinned cursors |
SELECT address, hash_value
FROM gv$sqlarea
WHERE sql_text LIKE '%<name_from_v$db_object_cache%'; |
