Database - RAC/Scalability (MOSC)

MOSC Banner

Server load high on rac node1

edited May 6, 2014 10:53AM in Database - RAC/Scalability (MOSC) 13 comments

Hi Experts,

Two node RAC 11.2.0.4. I always notice load on node1 server more than the node2. Node1 does more memory swapping compared to node2. This has become bit of worry as node1 load goes very high sometimes. Shouldn't the load be balancing across both nodes?

OS- OEL 6

[oracle]$ uname -r

2.6.39-400.209.1.el6uek.x86_64

Node-1

top - 09:09:31 up 208 days, 20:44,  6 users,  load average: 5.85, 5.18, 5.00

Node-2

top - 09:10:01 up 90 days, 21:40,  4 users,  load average: 3.34, 2.85, 2.21

[oracle@db1]$  free -m

             total       used       free     shared    buffers     cached

Mem:        129154     127906       1247          0         16     108402

-/+ buffers/cache:      19488     109665

Swap:        16483      10328       6155

[oracle@db2]$  free -m

             total       used       free     shared    buffers     cached

Mem:        129154     126784       2370          0        115     107166

-/+ buffers/cache:      19502     109651

Swap:        16483       7277       9206

[oracle@db1]$ vmstat 10 10

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center