Solaris huge Load issue

Hi,

I'm having an issue with my Solaris machine, Oracle Database performs very slow.

If I issue a prstat, CPU doesn't seem to be used.

  7746 oracle     17G 1251M sleep  101    -   0:15:28 2.1% oracle/1
  7767 oracle     17G 1283M sleep  101    -   0:15:34 2.1% oracle/1
    67 root     6408K 2352K cpu2     0    0 235:02:37 0.5% bash/1
  5823 grid      102M   87M sleep  100    -   0:06:36 0.5% ocssd.bin/20
  7704 oracle     17G 1253M sleep   39    0   0:05:29 0.4% oracle/1
 11593 grid       17G 2317M sleep   59    0   0:01:42 0.3% oracle/2
  5936 grid       17G 4592M sleep   52    0   0:01:24 0.3% oracle/2
  7280 oracle     17G 1215M sleep   49    0   0:01:50 0.3% oracle/1
 16931 grid       17G 2333M sleep   54    0   0:02:04 0.2% oracle/2
 19607 grid       17G 2269M sleep   54    0   0:02:06 0.2% oracle/2

Open in new window


Attached vmstat also:

 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr am s2 s3 sd   in   sy   cs us sy id
 0 0 0 17654256 7492592 6171 36740 17 10 10 0 0 1 9 8 -105406 10832 73400 11854 10 9 81
 165 0 0 11423000 5381344 3518 17832 0 0 0 0 0 0 0 0 0 17458 75115 17108 45 10 46
 193 0 0 11423944 5381256 88 615 0 0 0 0 0  0  0  0  0 19340 59795 19304 90 10 0
 52 0 0 11424120 5381408 1014 5498 0 0 0 0 0 0 0  0  0 22994 66228 22984 78 11 11
 0 0 0 11423576 5381016 4166 21173 0 0 0 0 0 0 0  0  0 15285 76845 15025 38 9 53

Open in new window



However, w command output shows a huge load:
120.64, 122.22, 106.15

Open in new window


psrinfo -pv
The physical processor has 8 virtual processors (0-7)
  SPARC64-VII+ (portid 1024 impl 0x7 ver 0xc1 clock 3000 MHz)
The physical processor has 8 virtual processors (136-143)
  SPARC64-VII+ (portid 1160 impl 0x7 ver 0xc1 clock 3000 MHz)

Open in new window


Also, my machine has: CPUs: 16 Cores: 8 Sockets: 2.

What's actually causing this load?

Please help.
LVL 1
g0allAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gerwin Jansen, EE MVETopic Advisor Commented:
I'm no solaris expert but what is that root process (pid 67) that has been using 235 hours of CPU time aleady? Is it some script that is causing a lot of IO maybe? That will slowdown your system.
0
g0allAuthor Commented:
It's just a bash process it seems, it seems it does no harm .
0
TintinCommented:
What's the output of

iostat -x 5

Post the 2nd or 3rd set of output.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

g0allAuthor Commented:
Issue stopped to occur and I haven't managed to collect any additional output, I will reopen the case of necessary.

Thank you very much!
0
Gerwin Jansen, EE MVETopic Advisor Commented:
Well, since the issue is resolved but we didn't really assist you I suggest you delete this question. Use 'Request Attention' to request deleting this.
0
g0allAuthor Commented:
There are two answers that will help me further.

Thanks :-)
0
Gerwin Jansen, EE MVETopic Advisor Commented:
Ok, thanks for your feedback ;)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Unix OS

From novice to tech pro — start learning today.