-
cpu utilization 100% need urgrnt help
HI friends
I am facing one problem whenever I start oracle server it runs good for sometime but after sometime the cpu utliisation goes to 100% but when I see the parameter "CPU used by this session" in v$stsstat it is showing 0 in values column what could be the reason?
please I need urgent help
Shailendra
-
R u sure that 100% CPU utilzation is by ORACLE.exe which is run as a process by WIN OS.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
without more information I can guess the following
I have encountered the same problem ealier while we had antivirus software installed on Windows/Oracle server or you have screen saver activated .
Disabling both of them will save you hanging danger.
Hisham Nagia
IT Manager For Development
Oracle Consultant - OCP
-
Re-Boot and call me back
MH
I remember when this place was cool.
-
its on Solaris
I have reboot it but it happens again and if you need some more information let me know
Shailendra
-
Originally posted by shailendra
its on Solaris
I have reboot it but it happens again and if you need some more information let me know
Shailendra
Thats very kind of you for helping us by giving the information...
Now would you please let us know things like
What OS ?? (Solaris what?? Intel ? Sparc ? OS version)
What Version of Oracle ?? (With patchset)
Any other Third part tool installed ??
What is the output of vmstat when the CPU is 100% ??
What is the output of top when the CPU is 100% ??
What is the output of sar when the CPU is 100% ??
Which user is utlizing 100% CPU ??
What are you running ??
What is the output of crontab -l ??
Are there any DBMS_JOBS running ??
Has this happened before ? What were the last few thing that you did just before this started ? Any major changes to OS or Oracle (like applying of patches) or any new software installed ?
??
Amar
"There is a difference between knowing the path and walking the path."
-
Sorry, I thought this was NT, I have encountered this problem on NT and a re-boot works wonders. Is there a way to track down the runaway process in Solaris?
Was the server (not the instance) re-booted?
MH
I remember when this place was cool.
-
What OS ?? (Solaris what?? Intel ? Sparc ? OS version)
Solaris Sparc 2.6
What Version of Oracle ?? (With patchset)
Oracle Server 8.1.6.0.0
Any other Third part tool installed ??
No
What is the output of vmstat when the CPU is 100% ??
r b w swap free re mf pi po fr de sr f0 s0 s1 s6 in sy cs us sy id
41 0 0 2403456 31544 7 35 14 75 108 31536 5 0 7 6 0 754 2262 398 96 4 0
42 0 0 2401200 31536 6 243 4 57 380 31536 52 0 9 4 0 691 2248 384 95 5 0
46 0 0 2395680 31400 8 304 19 86 446 23000 59 0 9 8 0 701 2127 410 95 5 0
48 0 0 2393400 31544 9 268 11 99 476 31536 67 0 21 8 0 852 2834 523 95 5 0
What is the output of top when the CPU is 100% ??
CPU states: 0.0% idle, 95.5% user, 4.5% kernel, 0.0% iowait, 0.0% swap
Memory: 2048M real, 32M free, 1359M swap in use, 2313M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
15478 oracle8 1 58 0 1193M 1173M run 0:22 1.97% oracle
15511 oracle8 1 58 0 1193M 1173M run 0:15 1.97% oracle
15509 oracle8 1 58 0 1193M 1173M run 0:16 1.96% oracle
15575 oracle8 1 58 0 1193M 1171M run 0:07 1.96% oracle
15585 oracle8 1 58 0 1193M 1173M run 0:05 1.96% oracle
15595 oracle8 1 58 0 1193M 1171M run 0:04 1.93% oracle
15567 oracle8 1 58 0 1193M 1173M run 0:07 1.93% oracle
15599 oracle8 1 58 0 1193M 1173M run 0:03 1.93% oracle
15606 oracle8 1 58 0 1193M 1170M run 0:03 1.93% oracle
15561 oracle8 1 58 0 1193M 1173M run 0:07 1.92% oracle
15603 oracle8 1 58 0 1193M 1172M run 0:03 1.92% oracle
15490 oracle8 1 58 0 1193M 1173M run 0:18 1.91% oracle
15614 oracle8 1 58 0 1193M 1170M run 0:03 1.91% oracle
15559 oracle8 1 58 0 1193M 1173M run 0:08 1.90% oracle
15587 oracle8 1 58 0 1193M 1173M run 0:04 1.89% oracle
What is the output of sar when the CPU is 100% ??
Which user is utlizing 100% CPU ??
oracle
What are you running ??
only database is runing
What is the output of crontab -l ??
Are there any DBMS_JOBS running ??
NO not now
-
Hi
whats the output of prstat command.
regards
Hrishy
-
Originally posted by shailendra
CPU states: 0.0% idle, 95.5% user, 4.5% kernel, 0.0% iowait, 0.0% swap
Memory: 2048M real, 32M free, 1359M swap in use, 2313M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
15478 oracle8 1 58 0 1193M 1173M run 0:22 1.97% oracle
15511 oracle8 1 58 0 1193M 1173M run 0:15 1.97% oracle
15509 oracle8 1 58 0 1193M 1173M run 0:16 1.96% oracle
15575 oracle8 1 58 0 1193M 1171M run 0:07 1.96% oracle
15585 oracle8 1 58 0 1193M 1173M run 0:05 1.96% oracle
15595 oracle8 1 58 0 1193M 1171M run 0:04 1.93% oracle
15567 oracle8 1 58 0 1193M 1173M run 0:07 1.93% oracle
15599 oracle8 1 58 0 1193M 1173M run 0:03 1.93% oracle
15606 oracle8 1 58 0 1193M 1170M run 0:03 1.93% oracle
15561 oracle8 1 58 0 1193M 1173M run 0:07 1.92% oracle
15603 oracle8 1 58 0 1193M 1172M run 0:03 1.92% oracle
15490 oracle8 1 58 0 1193M 1173M run 0:18 1.91% oracle
15614 oracle8 1 58 0 1193M 1170M run 0:03 1.91% oracle
15559 oracle8 1 58 0 1193M 1173M run 0:08 1.90% oracle
15587 oracle8 1 58 0 1193M 1173M run 0:04 1.89% oracle
Hmmm... This is intresting... your system seems to be f**ked up...
CPU usage is 100%, but all oracle8 user processes are consuming 1193M of memory not cpu, each oracle8 user CPU% consumption is around 1.90% approx. And what is this command oracle ??
Show you SGA... and init.ora parameters
CPU states: 0.0% idle, 95.5% user.
Who are the other users other than Oracle8 ??
try
$ who
Is there any system administrator around at your place ? ask him to find the bottle neck...
Amar
"There is a difference between knowing the path and walking the path."
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
|