Database Tuning (MOSC)

MOSC Banner

dbms_shared_pool.markhot - Hash value

edited Jun 27, 2016 2:34PM in Database Tuning (MOSC) 9 commentsAnswered

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

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