Database Tuning (MOSC)

MOSC Banner

Active sessions with not null lockwait

edited Jun 20, 2017 9:22AM in Database Tuning (MOSC) 11 commentsAnswered

Hello,

I'm working on a 12.1.0.2 two nodes RAC and I'm investigating a problem about 15 sessions of the same server that have a not null lockwait for a long time but the alert file doesn't include error message about this issue.

I ran the following requests:

select INST_ID,SID,SERIAL#,USERNAME,LOCKWAIT,STATE,STATUS,SCHEMANAME,OSUSER,MACHINE,PROGRAM,

to_char(LOGON_TIME,'DD/MM/YYYY HH24:MI:SS') "logon_time",

LAST_CALL_ET,EVENT

from gv$session

where lockwait is not null;

INST_ID   SID SERIAL# USERNAME             LOCKWAIT STATE               STATUS     SCHEMANAME                     OSUSER               MACHINE                    PROGRAM                     logon_time           LAST_CALL_ET EVENT

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