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!

(LOCAL=NO) Processes of Oracle

586405Aug 24 2007 — edited Aug 24 2007

Hi,

We have two application interacting with our Oracle Database.

After running the application for considerable amount of time, the cpu utilization of oracle reaches to 99%, and the box becomes the unaccesible.

When we sees the the processes using ps -ef | grep -i oracle<ORACLE_SID>, We found the no. of processes with:
oracle 16457 1 0 13:53 pts/0 00:00:00 oracle<ORACLE_SID> (LOCAL=NO)

What are this (LOCAL=NO) processes, why they are taking much CPU Utilization.

Thanks in Advance for your help.

Regards,
Manoj

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2007

Added on Aug 24 2007

#general-database-discussions

10 comments

5,625 views