Hanging Sessions on zOS Database Not Detected In Grid Control (Doc ID 464596.1)

Last updated on APRIL 24, 2017

Applies to:

Enterprise Manager Grid Control - Version: 10.2.0.2 and later   [Release: 10.2 and later ]
Enterprise Manager for RDBMS - Version: 10.1.0.2 and later    [Release: 10.1 and later]
IBM z/OS on System z

Symptoms

Hanganalysis requested from Advisor Central --> SQL Tuning Advisor --> Top Activity --> Hang Analysis  link in Grid Control generates the trace file succesfully :

///////////////////////////////////////////////////////////////////////////
/   Oracle for OS/390 Diagnostic Trace  --  2007/07/13  10:04:42.631      /
/ System LNA2     Subsystem OPSS Service MPPP     Session  46 PID 0273002E/
///////////////////////////////////////////////////////////////////////////
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security and Data Mining options
 OS/390 SP7.0.8 , CPU MODEL 2094
Instance name: MPPP
Redo thread mounted by this instance: 1
Oracle process number: 53
OSDI process pid: 0273002E, image:

*** SERVICE NAME:(SYS$USERS) 2007-07-13 10:04:42.572
*** SESSION ID:(985.18437) 2007-07-13 10:04:42.572
*** 2007-07-13 10:04:42.572
==============
HANG ANALYSIS:
==============
Open chains found:
Chain 1 : <cnode/sid/sess_srno/ospid/wait_event> :
    <0/1015/3407/00020057/SQL*Net message from client>
 -- <0/1023/31675/027A002C/enq: TX - row lock contention>
Other chains found:
Chain 2 : <cnode/sid/sess_srno/ospid/wait_event> :
    <0/982/56279/0B960024/db file sequential read>
Chain 3 : <cnode/sid/sess_srno/ospid/wait_event> :
    <0/985/18437/0273002E/No Wait>
Chain 4 : <cnode/sid/sess_srno/ospid/wait_event> :
    <0/994/1692/00030054/db file sequential read>

.....

 

but the blocking sessions are not displayed in the Grid Control screen.



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms