SO: 0xc000001842ba9750, type: 2, owner: 0x0000000000000000, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0xc000001842ba9750, name=process, file=ksu.h LINE:12616 ID:, pg=0
(process) Oracle pid:664, ser:2, calls cur/top: 0xc0000015e1989c10/0xc000001711b743a8
flags : (0x0) -
flags2: (0x0), flags3: (0x10)
intr error: -2147473260, call error: 0, sess error: 0, txn error 0
intr queue: 2147494036
ksudlp FALSE at location: 0
(post info) last post received: 2147494036 136 12
last post received-location: ksu.h LINE:13927 ID:ksusig
last process to post me: c000001832b0b620 242 0
last post sent: 0 0 356
last post sent-location: kxfp.h LINE:4561 ID:kxfprienq: slave
last process posted by me: c000001832b0b620 242 0
(latch info) wait_event=0 bits=50
holding (efd=10) c000001804617de8 Child parallel query alloc buffer level=6 child#=23
Location from where latch is held: kxfpb.h LINE:496 ID:kxfpbalo: allocate a buffer
Context saved from call: 13835058152010268280
state=busy [holder orapid=664] wlstate=free [value=0]
waiters [orapid (seconds since: put on list, posted, alive check)]:
746 (456, 1409025072, 2)
1068 (456, 1409025072, 3)
747 (456, 1409025072, 2)
857 (456, 1409025072, 1)
1067 (456, 1409025072, 3)
748 (456, 1409025072, 1)
983 (434, 1409025072, 4)
1070 (384, 1409025072, 3)
749 (384, 1409025072, 1)
1069 (384, 1409025072, 2)
912 (346, 1409025072, 4)
662 (323, 1409025072, 3)
871 (308, 1409025072, 4)
906 (270, 1409025072, 4)
735 (209, 1409025072, 4)
786 (157, 1409025072, 1)
972 (74, 1409025072, 1)
waiter count=17
holding (efd=10) c00000168571bdd0 Child process queue reference level=4 child#=10989
Location from where latch is held: kxfp.h LINE:4438 ID:kxfprialo2: process qref child init
Context saved from call: 13835058150030153416
state=busy [holder orapid=664] wlstate=free [value=0]
Process Group: DEFAULT, pseudo proc: 0xc0000018330dea98
O/S info: user: oracle, term: UNKNOWN, ospid: 28873
OSD pid info: Unix process pid: 28873, image: oracle@xx01 (P485)
PSO child state object changes :
Parallel Query 导致的ORA(6)
内容版权声明:除非注明,否则皆为本站原创文章。
转载注明出处:https://www.heiqu.com/40a5d2857651370c883e5166669d2e40.html