Database Tuning (MOSC)

MOSC Banner

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

-------------------- -------------------------------------------------- ------------------------------ ---------- ---------- ---------- -------------------------------- ----------

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center