dbms_shared_pool.markhot - Hash value
Hi All,
I'm planning to use dbms_shared_pool.markhot to overcome library cache mutex X contention.
exec dbms_shared_pool.markhot('HYCEA','CORE',1);
EXEC DBMS_SHARED_POOL.MARKHOT('HYCEA','CORE',2);
EXEC DBMS_SHARED_POOL.MARKHOT(HASH=>105208,NAMESPACE=>1);
i need clarifications regarding the HASH=>105208,NAMESPACE=>1
How to obtain the HASH value (105208) & namespace value (1) for a particular package & package body.
Oracle Version - 11.2.0.4.16
CPU - 16
SGA - 72 GB
PGA - 4 GB
Concurrent users - 10k