https://www.adminschool.net/wiki/ 2026-04-22T12:44:48+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:concept:owi:1day&rev=1759498250&do=diff OWI 1day 개념 stat 과 event 는? stat : 현 상태를 알려준다. event : 디비 안쪽에서 발생하는 일들 지연 - 경합 - 다른 세션이 끝날때까지 기다린다.(?) Lock 획득 Mode * Lock 획득 Mode를 확인할 수 있다. text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:concept:owi:2day&rev=1759498250&do=diff OWI 2Day SELECT /*+ ORDERED */ lo.kglnaobj AS object , decode( ll.kgllkmod , 0 , 'none' , 1 , 'null' , 2 , 'share' , 3 , 'exclusive' , ll.kgllkmod ) AS currentlockmode , decode( ll.kgllkreq , 0 , 'none' , 1 , 'null' , 2 , 'share' , 3 , 'exclusive' , ll.kgllkreq ) AS requestlockmode , ll.kgllktype TYPE , s.schemaname holderschema , s.program holderprogram , s.module holdermodule FROM dba_kgllock ll , x$kglob lo , v$sessi…