4 Replies Latest reply: Jun 4, 2008 6:39 PM by damorgan RSS

    ORA_P0* processes hitting performance on the box

    643130
      My database shows certain ORA-P0 processes starting at a specific time every week which is hitting the performance of my box in terms of IO and other metrics.

      Can anyone tell me if there is a way to schedule these processes and if so then how to stop them?

      Oracle version : 10.1.0.3
      OS : Solaris 9

      i wrote a script that runs every hour and counts the number of ora_p0xx tasks that are running on this box.

      Date 0000 0100 0200 0300 0400 0500 0600 0700 0800 0900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300
      ---------------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- --------
      20080522 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000

      20080523 0000 0000 0000 0012 0012 0012 0012 0012 0024 0024 0024 0024 0024
      ------------------------------------------------------------------------------------------------------------------------
      0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024

      20080524 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024 0024
      20080525 0024 0024 0012 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0012 0012 0012 0012 0012 0012 0000 0000 0000
      20080526 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
      20080527 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
      20080528 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
      20080529 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000

      20080530 0000 0000 0000 0012 0012 0012 0012 0012 0024 0024 0024
      -------------------------------------------------------------------------------------------------------
      <-so far today

      if you notice on Friday 23 May 2008 and Today Friday 30 May 2008 - 12 ora_p0xx tasks were running at 0300am and at 0800am there were 24 ora_p0xx tasks running. Since the counts are the same and they are starting at the same time it appears, to me, to be more that just random paralel tasks, something scheduled.

      I'd truly appreciate any thoughts. Thanks.