Parallel Query 导致的ORA(6)

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 :

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/40a5d2857651370c883e5166669d2e40.html