2 Replies Latest reply on Jul 7, 2009 4:15 PM by 649789

    ORA-12801: error signaled in parallel query server P000

    649789
      Hello All,

      Week before one of the APPLY process ABORTED with following error:

      ORA-12801: error signaled in parallel query server P000
      ORA-04031: unable to allocate 104 bytes of shared memory ("streams pool","unknown object","apply shared t","knalfGetTxn:lcr")
      We are using ORACLE 10.2.0.4.0 on HP unix B.11.23

      For now, I have started the APPLY process again and it's working properly.

      When I looked into the trace file it shows following
      A001: [enq: TM - contention] name|mode=544d0002, object #=2a67, table/partition=0
      *** 2009-06-15 10:53:57.897
      A001: warning -- apply server 1, sid 302 waiting on user sid 267 for event (since 302 seconds):
      A001: [enq: TM - contention] name|mode=544d0002, object #=2a67, table/partition=0
      *** 2009-06-15 10:58:58.792
      A001: warning -- apply server 1, sid 302 waiting on user sid 267 for event (since 603 seconds):
      A001: [enq: TM - contention] name|mode=544d0002, object #=2a67, table/partition=0
      *** 2009-06-15 12:14:36.679
      A001: [enq: TX - row lock contention] name|mode=54580004, usn<<16 | slot=90028, sequence=1b743
      *** 2009-06-15 12:19:36.961
      A001: warning -- apply server 1, sid 302 waiting on user sid 181 for event (since 300 seconds):
      A001: [enq: TX - row lock contention] name|mode=54580004, usn<<16 | slot=90028, sequence=1b743
      *** 2009-06-15 12:24:37.417
      A001: warning -- apply server 1, sid 302 waiting on user sid 181 for event (since 600 seconds):
      A001: [enq: TX - row lock contention] name|mode=54580004, usn<<16 | slot=90028, sequence=1b743
      *** 2009-06-15 12:29:37.906
      A001: warning -- apply server 1, sid 302 waiting on user sid 181 for event (since 901 seconds):
      A001: [enq: TX - row lock contention] name|mode=54580004, usn<<16 | slot=90028, sequence=1b743
      *** 2009-06-15 12:34:37.428
      A001: warning -- apply server 1, sid 302 waiting on user sid 181 for event (since 1201 seconds):
      A001: [enq: TX - row lock contention] name|mode=54580004, usn<<16 | slot=90028, sequence=1b743
      *** 2009-06-19 11:26:44.601
      A001: [enq: TX - row lock contention] name|mode=54580006, usn<<16 | slot=8001e, sequence=1a4af
      *** 2009-06-19 11:31:43.753
      A001: warning -- apply server 1, sid 302 waiting on user sid 212 for event (since 300 seconds):
      A001: [enq: TX - row lock contention] name|mode=54580006, usn<<16 | slot=8001e, sequence=1a4af
      *** 2009-06-19 11:36:44.149
      A001: warning -- apply server 1, sid 302 waiting on user sid 212 for event (since 600 seconds):
      A001: [enq: TX - row lock contention] name|mode=54580006, usn<<16 | slot=8001e, sequence=1a4af
      *** 2009-06-19 11:41:43.775
      A001: warning -- apply server 1, sid 302 waiting on user sid 212 for event (since 900 seconds):
      A001: [enq: TX - row lock contention] name|mode=54580006, usn<<16 | slot=8001e, sequence=1a4af
      *** 2009-06-23 16:55:24.002
      A001: [enq: TM - contention] name|mode=544d0004, object #=2c05, table/partition=0
      *** 2009-06-29 09:48:58.166
      A001: [enq: TM - contention] name|mode=544d0004, object #=2c05, table/partition=0
      *** 2009-07-01 06:02:37.236
      A001: [enq: TM - contention] name|mode=544d0004, object #=2c05, table/partition=0
      *** 2009-07-01 11:46:43.672
      error 12801 in STREAMS process
      ORA-12801: error signaled in parallel query server P000
      ORA-04031: unable to allocate 104 bytes of shared memory ("streams pool","unknown object","apply shared t","knalfGetTxn:lcr")
      OPIRIP: Uncaught error 447. Error stack:
      ORA-00447: fatal error in background process
      ORA-12801: error signaled in parallel query server P000
      ORA-04031: unable to allocate 104 bytes of shared memory ("streams pool","unknown object","apply shared t","knalfGetTxn:lcr")


      Can you please help to provide details on that how i can fix this problem permanetely.

      Any suggestions would be great!

      Thanks,
      Nick