-
Hi all
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...
PNRDBA
-
those are Parallel processes
-
Hi Pando,
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
thanks
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|