My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2020

Applies to:

Enterprise Manager Base Platform - Version and later
Enterprise Manager for Oracle Database - Version and later
IBM z/OS on System z


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 - 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
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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.