- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
2#
发表于 2014-2-12 21:24:17
SADDR RAW(8)
SID NUMBER
SERIAL# NUMBER
QCSID NUMBER
QCSERIAL# NUMBER
QCINST_ID NUMBER
SERVER_GROUP NUMBER
SERVER_SET NUMBER
SERVER# NUMBER
DEGREE NUMBER
REQ_DEGREE NUMBER
GV$PX_SESSION
SELECT a.inst_id,
a.addr, SADDR
a.indx, SID
a.ksuseser, SERIAL
DECODE(b.kxfpdpqcsid,NULL,a.indx,b.kxfpdpqcsid), QCSID
b.kxfpdpqcser, QCSERIAL
b.kxfpdpcin, QCINST_ID
b.kxfpdpsvgrp, SERVER_GROUP
b.kxfpdpsvset, SERVER_SET
b.kxfpdpsvnum,SERVER
b.kxfpdpadg, DEGREE
b.kxfpdprdg REQ_DEGREE
FROM x$ksuse a,
x$kxfpdp b
WHERE bitand(a.ksspaflg,1)!=0
AND bitand(a.ksuseflg,1) !=0
AND a.ksuseqcsid > 0
AND a.ksusepro = b.kxfpdppro(+)
kxfpdpsvgrp ==> SERVER_GROUP ==> Slave group number
kxfpdpsvset ==> SERVER_SET ==> Slave number within set
|
|