시스템 덤프 분석 오라클 세미나자료입니다.
(session) trans: 0, flag: (51) USR/- BSY/-/-/-/-/-
oct: 0, prv: 0, user: 0/SYS
waiting for 'pmon timer' seq=21909 wait_time=0
duration=12c, =0, =0
Code Structure: ksuse
trans.........Address of transaction state object.
flag..........Hex bitmask in brackets meaning :
0x0001 - A user session rather than a recursive session.
0x0002 - A recursive session (always internal) @@@
0x0004 - Audit logon/logoff (used by cleanup) @@@
0x0008 - Disable commit/rollback from plsql
0x0010 - user session created by system processes @@@
0x0020 - Set when the UGA is allocated in the SGA
0x0040 - whether user session logs on to ORACLE @@@@
0x0080 - User session created by MTS.
0x0100 - Disable (defer) interrupt. @@
0x0200 - Counted for current license count decrement
0x0400 - Session has been detached.
0x0800 - Session is not MAC except.
0x1000 - (Cloned) Session is cached. @@@
0x2000 - Default transaction isolation levl is serializable.
0x4000 - Override serializable for READ COMMITTED.
This is then followed by a string which interprets this (and another)
bitmask. The three letter codes are optionally set and indicate the
USR - User session
REC - Recursive session
BSY - Session is busy. It's in a call.
TBD - Session marked dead by idle sniper. @@ explain about pmon etc@
DED - Session marked dead by user process.
DEL - Session being deleted (via alter system kill session).
KIL - Session marked for kill (via alter system kill session).
KLD - Session has been killed (via alter system kill session).
oct...........Oracle command type (see octdef.h) in progress.
prv...........User priveleges @@@