TM
2010.12.29 01:36

SystemState 세미나자료

조회 수 11009 추천 수 0 댓글 0
Atachment
첨부 '1'

시스템 덤프 분석 오라클 세미나자료입니다.

첨부파일 참고하세요...

 Example: 

(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

Meaning:

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

following :

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 @@@

user..........Oracle Userid.


List of Articles
번호 분류 제목 글쓴이 날짜 조회 수
공지 Q&A Oracle관련 게시물만 Sean 2014.04.09 84902
140 TM 엔지니어필수품 file perfstat 2011.03.03 14115
139 TM RAC10g R2 patch(10.2.0.1->10.2.0.5) file 윤현 2011.03.02 10715
138 TM oracle client 와 database 간 상호 호환성(version) 1 담벼락 2011.01.24 23201
137 TM Automatic Storage Management file 담벼락 2010.12.31 10629
136 TM 10g Transportable Tablespace 에 대한 세미나 자료 입니다 file 송기성 2010.12.29 9204
135 TM Replication 세미나 자료 file 고구마 2010.12.29 11200
» TM SystemState 세미나자료 file 고구마 2010.12.29 11009
133 TM Database Replay 담벼락 2010.12.27 9503
132 TM ORA-1578 조치를 위한 event 10231 1 이성철 2010.12.22 8449
131 TM (10g) 자동 통계정보 수집(AUTOMATIC OPTIMIZER STATISTICS COLLECTION) 담벼락 2010.12.16 16383
130 TM 오라클 디렉토리 변경 송기성 2010.12.16 24978
129 TM UPDATABLE SNAPSHOT 구축하기 고구마 2010.08.23 15507
128 TM replication table 다른 tablespace 로 옮기기 고구마 2010.08.23 13822
127 TM Flashback Query 승현짱 2010.05.30 8675
126 TM analyze connection failover options 유주환 2010.05.19 8864
125 TM 어플리케이션 페일오버와 로드밸런싱 유주환 2010.05.19 8843
124 TM fine-grained_auditing 1 유주환 2010.05.19 8594
123 TM library_cache_lock,_library_cache-orapybubu 유주환 2010.05.19 8871
122 TM fga와_vpd를_이용한_오라클_데이터베이스_보안_관련_문제와_답변 유주환 2010.05.19 10405
121 TM 과도한 CPU 및 UNDO REDO 많이 사용하는 세션 찾기 1 고구마 2010.05.19 23731
Board Pagination Prev 1 2 3 4 5 6 7 8 Next
/ 8