Skip to Main Content

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!

Run Queue

936749Jun 8 2012 — edited Jun 8 2012
Hi,
I have a system with 31 databases running and when running vmstat 5 5 I get the following:
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
43 12 0 9384607 9197758 0 0 24 11 0 0 414 49939 704738 29358 52 17 31
43 12 0 9384607 9186170 0 0 1 3 0 0 0 40638 1085122 38446 85 14 1
50 8 0 9467427 9172458 0 0 1 4 0 0 0 44732 1237572 46874 82 15 3
50 8 0 9467427 9220610 0 0 0 4 0 0 0 39450 1204662 51553 82 15 3
45 12 0 9446969 9197194 0 0 0 4 0 0 0 44293 1004155 40134 81 17 3
If the formating above is ok you could see that run queue is 43 - 50 on these 5 samples. This is on a 16 CPU(grid control info) HP-UX Itanium server.
If I look in Grid control I get the following info:
Real Time Statistics
Current Value 1.64
Average Value 2.0
High Value 2.73
Low Value 1.64
Warning Threshold 10
Critical Threshold 20
Occurrences Before Alert 6
Corrective Action None

Why the big difference?
Also I've tried to run vmstat several times and it always show 25+ in Run Queue

I think we have problems with CPU resources(and then again performence in databases) and trying to document it.
Regards
933746
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2012
Added on Jun 8 2012
5 comments
409 views