dbms_shared_pool.markhot LRU question
Hello
I would like to kindly ask you
If object marked as HOT is influenced by least-recently-used LRU algorith
and therefore can be removed from shared pool / library cache ?
object is not influenced by alter system flush shared pool;
sys.dbms_shared_pool.markhot(hash=>'b3dbd4abf1156b09780cbaeb8ba84e61',namespace=>0,global=>true);
select owner,name,namespace,type,executions,property, full_hash_value,hash_value
from v$db_object_cache where FULL_hash_value = 'b3dbd4abf1156b09780cbaeb8ba84e61';
OWNER NAME NAMESPACE TYPE EXECUTIONS PROPERTY FULL_HASH_VALUE HASH_VALUE
-------------------- -------------------------------------------------- ------------------------------ ---------- ---------- ---------- -------------------------------- ----------