Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

how to find old session information

We are running Oracle 19c, and found the following line in alert log file,

KILL SESSION for sid=(39, 7377):

 Reason = profile limit idle_time

 Mode = KILL SOFT -/-/NO_REPLAY

 Requestor = PMON (orapid = 2, ospid = 17416, inst = 1)

 Owner = Process: USER (orapid = 257, ospid = 18059)

 Result = ORA-0

How I can find out what's userid for session (39,7377) to be killed?

Thanks a lot for your help,

Katherine

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