Database Administration (MOSC)

MOSC Banner

SESSION ID in trace file

edited Oct 5, 2022 9:59AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi,

On 11.2.0.4 on AIX ,

In alert log I have :

Tue Oct 04 15:31:25 2022

Errors in file /u01/diag/rdbms/mydb/mydb/trace/mydb_ora_35848542.trc:

ORA-00028: your session has been killed

And in mydb_ora_35848542.trc file , I see:

*** 2022-10-04 15:31:25.877

*** SESSION ID:(859.19643) 2022-10-04 15:31:25.877

What is SESSION ID here?

In v$session I have no row for SID=859.

How can I find user or session or other more information ? Or how /by who it was killed?

Thanks.

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