Database - RAC/Scalability (MOSC)

MOSC Banner

enq: HV - contention

edited Oct 18, 2018 3:54AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

I am testing on X4-2 ExaD and seeing major contention on the cluster using 12.1 of the database.  We are running a DOP=192, bigfile TS with 32K blocksize.  Using TEMP groups for user temp area.  Here is the statement that is 100% contention in the cluster.

insert /*+ append */ /* rule: THINGSAM */ into MDSYS.RDF#13 (start_node_id, p_value_id, canon_end_node_id /* NGLI_PJ */ ) select s_id, sys_op_numtoraw(6459981115371763560), s_id /* NGLI_OS */ from ( select /*RULE_HINT*/ distinct start_node_id s_id /* NGLI_IS */ from ( select start_node_id, p_value_id, canon_end_node_id, null AS distance from MDSYS.RDF#13#2 s union all select start_node_id, p_value_id, canon_end_node_id, distance from MDSYS.RDF#13) m1 where p_value_id = sys_op_numtoraw(834132227519661324) and canon_end_node_id = sys_op_numtoraw(4016149533173549788) /* NGLI_AP */ ) where not exists ( select /*+ HASH_AJ */ 1 from ( select start_node_id, p_value_id, canon_end_node_id, null AS distance from MDSYS.RDF#13#2 s union all select start_node_id, p_value_id, canon_end_node_id, distance from MDSYS.RDF#13) x where

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