Skip to Main Content

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!

Too Many oracle ora_p0?? processes in Solaris 10

611668Dec 3 2007 — edited Dec 4 2007
I have a very intense update process which has about 8 SQL query - every one of them is having the HINT "NO_PARALLEL" as well as the stmt "Alter session disable dml;" before we execute the query.
Even the Index is also hinted as no parallel.

Every time this process run, i see number of ora_p??? process comes up and it never went goes down.

No when ever this happens, I am seeing lot of slowness in my transaction times. Please help and advice....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2008
Added on Dec 3 2007
7 comments
4,411 views