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