Too Many oracle ora_p0?? processes in Solaris 10
611668Dec 3 2007 — edited Dec 4 2007I 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....