Database Administration (MOSC)

MOSC Banner

mmon session blocking itself?

edited Feb 28, 2019 8:24AM in Database Administration (MOSC) 2 commentsAnswered

Oracle 12.1.0.2 SE-2 on Oracle Linux 6, with stand-alone ASM (not RAC, no clustering of any kind)

I have a job that runs every 5 minutes to check for blocking sessions, and send me an email if one is detected.  The core of that code is this query:

for c1 in  (select NVL(s1.username,'null') username1,                s1.machine machine1,                s1.sid sid1,                s1.serial# serial1,                s1.osuser osuser1,                s1.program program1,                lo.object_id locked_object,                NVL(s2.username,'null') username2,                s2.machine machine2,                s2.sid sid2,                s2.serial# serial2,                s2.osuser osuser2,                s2.program program2,                sqlt.sql_text sql_text2         from   v$lock l1,

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