使用方法：1. 在數(shù)據(jù)庫服務(wù)器上使用sys帳戶登陸： sqlplus / as sysdba2. 按以下順序操作：SQL> @get_lock.plbSQL> set serveroutput onSQL> set linesize 132SQL> exec get_locks;
將以下代碼保存為一個(gè)plb文件，如get_lock.plb
create or replace procedure get_locks wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
b38 37c
kuShPpEAa9bu4Ofv/cJP6O42BWgwg9dcTCDrfI5Dvp0GIlnA1QE8g/AHDcUJJTBsVvDWkHwI
jr3D8CeUWl/GczDiJNN2t9DLUKJ33/AQwBC7rf60vo/9b5ysr3P5gDLkMzru89Ot+91y6I7x
mVqISk0XpvoJYT5wJ7tjkWaZv3RINpqvB4L6GlkwOb8giDmJoXT25z4ZFy9jz8fZog5qtAyu
NeMkO+57e0JXdtC4P7I2QUFxqSiJrUAtPl3lHD6oxKFdIV8LN0Ja7AqqgnEo7odXlqoxQWFD
UCs1e1nVIOEHgM4aFnrP7Vslk+s+X+nRC9iUYK7tFJOq+lxMGLbUvOIY1nxNtem2wc3I/IMI
c0KkekfgdBu0+PH64RndAtrzJRRBHj2lua5WitvgPUj8vEG5ZFM41QTVmsGzsYRDK16R53x6
OqRDbde7ZXLmeiMHoeoi/1/lYB6rliKLzVIT1qu/XBiMS2VkhaMW6ujJzQ9cMOTaUvOEGKSz
ZqJ+E5Fg8PRFpuqD+hic6Ydvjp1c7JF+8jydD5Wc7S20+dpFOx1LGwNcD2c34Fn0VfRapk6x
+4MCR1B/MA/RnIN6yCcEwGTKH5AvtqEg++ejdDfnoRqHZfphzqmolluzPDM5ktC2irDobR6c
NF8neBFZ+6HoSm6JTnH+CZ2JrDywl8perPzvycjFAsy5/evC7ZXQ+pNJhdTTeqidTZBPi21r
xo6u1cZZc59mcrcPky5ckrAigjt4D3qdAqTUgUqxAX9J8gMo8DGvMW/zIynmmPcnhgk1ZPj3
b8CBnf3Y6wGwWFn+VchKEHMeYWStRUD1olnHdfAwrwCaQPV+yJLb/SXMaR2+/MecI7RlFDlz
Vuq36iT7NZFfNQ==
/