linux查看蓝牙pin码,查看pin

x$kglpn基表﹕

X$KGLPN--[K]ernel [G]eneric [L]ibrary Cache Manager object [P]i[N]s

它是與x$kgllk相對應的表﹐是關于pin的相關資訊

引用該表的相關視圖﹕

DBA_KGLLOCK

表相關欄位的描述﹕

SQL> desc x$kglpn;

名稱         類型

------------ ----------------------------

ADDR         RAW(4)

INDX         NUMBER

INST_ID      NUMBER

KGLPNADR     RAW(4)

KGLPNUSE     RAW(4)          ---會話地址

KGLPNSES     RAW(4)          ---owner地址

KGLPNHDL     RAW(4)          ---句柄

KGLPNLCK     RAW(4)

KGLPNCNT     NUMBER

KGLPNMOD     NUMBER          ---pin的當前模式(0為no lock/pin held﹐1為null,2為share﹐3為exclusive)

KGLPNREQ     NUMBER          ---pin當前需求的模式(0為no lock/pin held﹐1為null,2為share﹐3為exclusive)

KGLPNDMK     NUMBER

KGLPNSPN     NUMBER          ---對應跟蹤文件的savepoint的值

select a.sid,a.username,a.program,b.addr,b.KGLPNADR,b.KGLPNUSE,b.KGLPNSES,b.KGLPNHDL,

b.kGLPNLCK, b.KGLPNMOD, b.KGLPNREQ

from v$session a,x$kglpn b

where a.saddr=b.kglpnuse

and b.kglpnhdl = '0700000461731FF8'

and b.KGLPNMOD<>0;