336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
오라클 V$LOCK 뷰
V$LOCK 뷰는 Oracle Database가 보유하고있는 LOCK과 latch에 대한 미해결 정보를 보여준다.
Column | Datatype | Description |
---|---|---|
ADDR | RAW(4 | 8) | Address of lock state object |
KADDR | RAW(4 | 8) | Address of lock |
SID | NUMBER | Identifier for session holding or acquiring the lock |
TYPE | VARCHAR2(2) | Type of user or system lock The locks on the user types are obtained by user applications. Any process that is blocking others is likely to be holding one of these locks. The user type locks are:
The locks on the system types are held for extremely short periods of time. The system type locks are listed in Table 4-1. |
ID1 | NUMBER | Lock identifier #1 (depends on type) |
ID2 | NUMBER | Lock identifier #2 (depends on type) |
LMODE | NUMBER | Lock mode in which the session holds the lock:
|
REQUEST | NUMBER | Lock mode in which the process requests the lock:
|
CTIME | NUMBER | Time since current mode was granted |
BLOCK | NUMBER | The lock is blocking another lock |
'IT 이야기 > 데이터베이스(DB)' 카테고리의 다른 글
오라클 에러 코드 모음 (0) | 2017.03.16 |
---|---|
쿼리 정리 사이트 poorsql.com (0) | 2017.03.15 |
오라클 V$LOCKED_OBJECT (0) | 2017.03.15 |
오라클 세션(session) 확인 및 KILL (0) | 2017.03.15 |
오라클 락(lock) 확인 및 KILL (0) | 2017.03.15 |