| Oracle processes causing 100 % CPU usage [message #65130] |
Thu, 13 May 2004 21:01  |
prashant
Messages: 122
Registered: September 2000
|
Senior Member |
|
|
Hi all,
We have installed an oracle database server and an oracle forms server on one machine. If the corresponding windows service for the forms server is stopped and only the database instance is up and running there are no issues, but however the moment we start the forms service and as soon as we try to access one form from the browser, the CPU usage just shoots up 100%. The task monitor shows that the two processes (oracle.exe and ifweb60.exe) are hogging the CPU. We have been using this configuration for around 5 months now and only recently have we witnessed this behaviour. Any help or pointers would be highly appreciated.
TIA
Prashant
|
|
|
|
| Re: Oracle processes causing 100 % CPU usage [message #65132 is a reply to message #65130] |
Fri, 14 May 2004 05:49  |
Satish Shrikhande
Messages: 167
Registered: October 2001
|
Senior Member |
|
|
Find out what are the SQL's running on that server .
Check how much time does it take to execute , most of the time if you have huge SQL oracle.exe consumes 100% CPU , telling you by experience .
It's not a good idea to have database and application on same server . You will see this problem quite often , keep the database seperate and do not install any other software
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
