现在数据库里面全是这种锁~~~郁闷,找不到原因啊
SQL> select * from v$lock order by ctime;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
---------------- ---------------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
0000000454324860 0000000454324880 866 XR 4 0 1 0 1 2
000000045432C180 000000045432C1A0 691 TX 2686980 524808 0 6 69 0
0000000439CFD0C8 0000000439CFD0F0 691 TM 51912 0 3 0 69 2
000000045432C0D8 000000045432C0F8 419 TX 2686980 524808 0 6 73 0
0000000439CFCFA8 0000000439CFCFD0 419 TM 51912 0 3 0 73 2
0000000439CFCB28 0000000439CFCB50 25 TM 51912 0 3 0 81 2
000000045432C030 000000045432C050 25 TX 2686980 524808 0 6 81 0
0000000439CFC8E8 0000000439CFC910 304 TM 51912 0 3 0 97 2
000000045432BEE0 000000045432BF00 304 TX 2686980 524808 0 6 97 0
0000000439CFCE88 0000000439CFCEB0 312 TM 51912 0 3 0 102 2
000000045432BF88 000000045432BFA8 312 TX 2686980 524808 0 6 102 0
0000000439CFCD68 0000000439CFCD90 384 TM 51912 0 3 0 104 2
000000045432BE38 000000045432BE58 384 TX 2686980 524808 0 6 104 0
0000000439CFC7B0 0000000439CFC7D8 274 TM 51912 0 3 0 173 2
000000045432BD90 000000045432BDB0 274 TX 2686980 524808 0 6 173 0
0000000439CFCC48 0000000439CFCC70 311 TM 51912 0 3 0 182 2
000000045432BCE8 000000045432BD08 311 TX 2686980 524808 0 6 182 0
0000000439CFCA08 0000000439CFCA30 172 TM 51912 0 3 0 186 2
000000045432BC28 000000045432BC48 172 TX 2686980 524808 0 6 186 0
0000000439CFC570 0000000439CFC598 9 TM 51912 0 3 0 193 2
000000045432BB80 000000045432BBA0 9 TX 2686980 524808 0 6 193 0
000000045432B988 000000045432B9A8 247 TX 2686980 524808 0 6 221 0
0000000439CFC690 0000000439CFC6B8 247 TM 51912 0 3 0 221 2
000000045432BA30 000000045432BA50 729 TX 2686980 524808 0 6 223 0
0000000439CFC450 0000000439CFC478 729 TM 51912 0 3 0 223 2
0000000439CFBFD0 0000000439CFBFF8 417 TM 51912 0 3 0 225 2
000000045432BAD8 000000045432BAF8 417 TX 2686980 524808 0 6 225 0
0000000439CFC330 0000000439CFC358 344 TM 51912 0 3 0 259 2
000000045432B8E0 000000045432B900 344 TX 2686980 524808 0 6 259 0
0000000439CFBE98 0000000439CFBEC0 607 TM 51912 0 3 0 263 2
000000045432B838 000000045432B858 607 TX 2686980 524808 0 6 263 0
000000045432B790 000000045432B7B0 565 TX 2686980 524808 0 6 271 0
0000000439CFC210 0000000439CFC238 565 TM 51912 0 3 0 271 2
000000045432B6E8 000000045432B708 389 TX 2686980 524808 0 6 273 0
0000000439CFC0F0 0000000439CFC118 389 TM 51912 0 3 0 273 2
000000045432B640 000000045432B660 235 TX 2686980 524808 0 6 274 0
0000000439CFBC58 0000000439CFBC80 235 TM 51912 0 3 0 274 2
000000045432B598 000000045432B5B8 273 TX 2686980 524808 0 6 279 0
0000000439CFBB38 0000000439CFBB60 273 TM 51912 0 3 0 279 2
0000000439CFB8F8 0000000439CFB920 160 TM 51912 0 3 0 281 2
000000045432B448 000000045432B468 160 TX 2686980 524808 0 6 281 0
000000045432B4F0 000000045432B510 600 TX 2686980 524808 0 6 281 0
0000000439CFBD78 0000000439CFBDA0 600 TM 51912 0 3 0 281 2
000000045432B3A0 000000045432B3C0 686 TX 2686980 524808 0 6 284 0
0000000439CFB7D8 0000000439CFB800 686 TM 51912 0 3 0 284 2
0000000439CFB6B8 0000000439CFB6E0 723 TM 51912 0 3 0 288 2
000000045432B2F8 000000045432B318 723 TX 2686980 524808 0 6 288 0
000000045432B250 000000045432B270 822 TX 2686980 524808 0 6 294 0
0000000439CFA5A8 0000000439CFA5D0 822 TM 51912 0 3 0 294 2
000000045432B190 000000045432B1B0 322 TX 2686980 524808 0 6 298 0
0000000439CFB340 0000000439CFB368 322 TM 51912 0 3 0 298 2
000000045432B0E8 000000045432B108 755 TX 2686980 524808 0 6 302 0
0000000439CFBA18 0000000439CFBA40 755 TM 51912 0 3 0 302 2
000000045432B040 000000045432B060 566 TX 2686980 524808 0 6 303 0
0000000439CFB100 0000000439CFB128 566 TM 51912 0 3 0 303 2
0000000439CFB460 0000000439CFB488 702 TM 51912 0 3 0 304 2
0000000439CFB580 0000000439CFB5A8 59 TM 51912 0 3 0 304 2
000000045432AF98 000000045432AFB8 59 TX 2686980 524808 0 6 304 0
000000045432AEF0 000000045432AF10 702 TX 2686980 524808 0 6 304 0
0000000439CFAFE0 0000000439CFB008 680 TM 51912 0 3 0 305 2
000000045432AE48 000000045432AE68 680 TX 2686980 524808 0 6 305 0
000000045432ADA0 000000045432ADC0 386 TX 2686980 524808 0 6 306 0
0000000439CFB220 0000000439CFB248 386 TM 51912 0 3 0 306 2
0000000439CFAEC0 0000000439CFAEE8 713 TM 51912 0 3 0 309 2
000000045432AC50 000000045432AC70 713 TX 2686980 524808 0 6 309 0
0000000439CFAC68 0000000439CFAC90 387 TM 51912 0 3 0 315 2