Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA_P0* processes hitting performance on the box

643130Jun 4 2008 — edited Jun 4 2008

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2008

Added on Jun 4 2008

#general-database-discussions

4 comments

3,414 views