Norman Manzo Nora
asked on
How to reduce the HP-UX CPU loading when running Oracle SQL Update statement
Hi,
I have executed a number of UPDATE statements in Oracle SQLplus and I noticed that the CPU loading (I'm using "sar" in HP-UX) reaches above 95%. After the UPDATE statements were processed completely, the CPU load goes back to normal of about 5-10% only , Is there a way to reduce/limit the CPU loading to a maximum of 50% when using UPDATE statement?
OS: HP-UX
Processor: 4-CPU
Oracle: 11g
BTW, when I use SELECT statements, it does not reach 95%.
I have executed a number of UPDATE statements in Oracle SQLplus and I noticed that the CPU loading (I'm using "sar" in HP-UX) reaches above 95%. After the UPDATE statements were processed completely, the CPU load goes back to normal of about 5-10% only , Is there a way to reduce/limit the CPU loading to a maximum of 50% when using UPDATE statement?
OS: HP-UX
Processor: 4-CPU
Oracle: 11g
BTW, when I use SELECT statements, it does not reach 95%.
what is the update doing? Are there triggers?
if it's consuming cpu, with what is the cpu busy during that time?
if it's consuming cpu, with what is the cpu busy during that time?
ASKER
Hi Slightwv, unfortunately, it is affecting other some critical application processes when the update statement is ran.
To sdstuber, I've attached the sar command output.
I'm using a simple update statement command and somehow, the SQL statement is consuming so much CPU resource.
2015-05-06-224920.jpg
2015-05-06-223149.jpg
To sdstuber, I've attached the sar command output.
I'm using a simple update statement command and somehow, the SQL statement is consuming so much CPU resource.
2015-05-06-224920.jpg
2015-05-06-223149.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
why the penalty grade?
You "can" use resource management to limit OS resources:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11852
I placed "can" in quotes because you might not want to do this.
95% CPU utilization is only a problem if other processes are degraded. If normal CPU is 5-10%, what other apps slow down when your update statement uses 95%? If none, then let Oracle use the available resources. It isn't impacting anything.