안녕하세요 운영중인 db에서 다음과 같이 쿼리를 날렷는데, 궁금한점이 생겻네요
lock 타입에서 MR (media recovery)인놈들이 왜이리 많은건지 알고싶어요
다른 db를 봐도 MR이 많네요 SID는 모두 2번이고 .. 뭔가 있는거 같은데 알려주시면 감사합니다.
SQL> select addr,sid,type from v$lock ;
ADDR SID TY
---------------- ---------- --
00000003AC591A00 2 MR
00000003AC591920 2 MR
00000003AC5918B0 2 MR
00000003AC591840 2 MR
00000003AC5917D0 2 MR
00000003AC591760 2 MR
00000003AC5916F0 2 MR
00000003AC591680 2 MR
00000003AC591610 2 MR
00000003AC5915A0 2 MR
00000003AC591530 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC5914C0 2 MR
00000003AC591450 2 MR
00000003AC5913E0 2 MR
00000003AC591370 2 MR
00000003AC591300 2 MR
00000003AC591290 2 MR
00000003AC591220 2 MR
00000003AC5911B0 2 MR
00000003AC591140 2 MR
00000003AC5910D0 2 MR
00000003AC591060 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC590FF0 2 MR
00000003AC590F80 2 MR
00000003AC590F10 2 MR
00000003AC590EA0 2 MR
00000003AC590E30 2 MR
00000003AC590DC0 2 MR
00000003AC590D50 2 MR
00000003AC590CE0 2 MR
00000003AC590C70 2 MR
00000003AC590C00 2 MR
00000003AC590B90 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC590B20 2 MR
00000003AC590AB0 2 MR
00000003AC590A40 2 MR
00000003AC5909D0 2 MR
00000003AC590960 2 MR
00000003AC5908F0 2 MR
00000003AC590880 2 MR
00000003AC590810 2 MR
00000003AC5907A0 2 MR
00000003AC590730 2 MR
00000003AC5906C0 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC590650 2 MR
00000003AC5905E0 2 MR
00000003AC590570 2 MR
00000003AC590500 2 MR
00000003AC590490 2 MR
00000003AC590420 2 MR
00000003AC5903B0 2 MR
00000003AC590340 2 MR
00000003AC5902D0 2 MR
00000003AC590260 2 MR
00000003AC5901F0 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC590180 2 MR
00000003AC590110 2 MR
00000003AC5900A0 2 MR
00000003AC590030 2 MR
00000003AC58FFC0 2 MR
00000003AC58FF50 2 MR
00000003AC58FEE0 2 MR
00000003AC58FE70 2 MR
00000003AC58FE00 2 MR
00000003AC58FD90 2 MR
00000003AC58FD20 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC58FCB0 2 MR
00000003AC58FC40 2 MR
00000003AC58FBD0 2 MR
00000003AC58FB60 2 MR
00000003AC58FAF0 2 MR
00000003AC58FA80 2 MR
00000003AC58FA10 2 MR
00000003AC58F9A0 2 MR
00000003AC58F930 2 MR
00000003AC58F8C0 2 MR
00000003AC58F850 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC58F7E0 2 MR
00000003AC58F770 2 MR
00000003AC58F700 2 MR
00000003AC58F690 2 MR
00000003AC58F620 2 MR
00000003AC58F5B0 2 MR
00000003AC58F540 2 MR
00000003AC58F4D0 2 MR
00000003AC58F460 2 MR
00000003AC58F3F0 2 MR
00000003AC58F380 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC58F310 2 MR
00000003AC58F2A0 2 MR
00000003AC58F230 2 MR
00000003AC58F1C0 2 MR
00000003AC58F150 2 MR
00000003AC58F0E0 2 MR
00000003AC58F070 2 MR
00000003AC58F000 2 MR
00000003AC58EF90 2 MR
00000003AC58EF20 2 MR
00000003AC58EEB0 2 MR
ADDR SID TY
---------------- ---------- --
00000003AC58EE40 2 MR
00000003AC58EDD0 2 MR
00000003AC58ED60 2 MR
00000003AC58ECF0 2 MR
00000003AC58EC80 2 MR
00000003AC58EC10 2 MR
00000003AC58EBA0 2 MR
00000003AC58EB30 2 MR
00000003AC591A70 3 RT
00000003AC591B50 5 TS
00000003AC58EAC0 5 TS
ADDR SID TY
---------------- ---------- --
00000003AC58EA50 5 TS
00000003AC58E9E0 5 TS
00000003AC58E7B0 5 TS
113 rows selected. |