Os version is linux 7.1 and oracle 9.0.1
I'm getting this processes when i type ps ux
ora_p000,ora_p001... to 0ra_p005 . what are these?? and my server performance went down completely.
my parallel_max_servers are set to 5 and max_dispatchers are also set to 5.
Mine is a single instance server.
Please advice me...
those are Parallel processes
Our server is a dedicated one with single CPU. DB is very slow performance. The parameters ,
parallel_max_servers is set to default 5. In order to get rid out of these parallel queries , what to do? please help me
Click Here to Expand Forum to Full Width