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!

excessive LOCAL=NO oracle processes

622296May 12 2008 — edited May 15 2008

Hi

1) When trying to run application, database hangs due to excessive amount of processes:
oracle oracle (LOCAL=NO). How to kill those processes? Why these much processes are generated automatically?

2) While running prstat -a command on Sun Solaris 10, we get 100% CPU utilization by oracle user. At the same time, running top command gives us 5G free physical memory. What is the real memory usage in the same server by oracle?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 12 2008

Added on May 12 2008

#general-database-discussions

44 comments

20,732 views