Database Software

Hi gurus,

like you can see in my others post, i'm a newbie with RAC (actually im the DBA but 2 weeks ago i was programmer).

ORACLE: 11.2.0.3
S.O: Red hat 5.3
RAC with 2 nodes
ASM

My problem is that i don't know why one nothe has more load than the other, and how to solved it:

INST SID SERIAL# USERNAME OSUSER PROGRAM BGETS BCHANGES BLOCKS_IO CPU LOGON_TIME
---- ---- ------- ---------- --------------- ---------------------------------------- --------------- --------------- ---------------- ------------ ----------------

1 401 41915 DB oper1 ssee @node1 (TNS V1-V3) 18,143,734 11,749,218 29,892,952 30,890 2012/03/04 09:20
1 594 199 DB oper1 jp @node1 (TNS V1-V3) 13,304,304 9,671,680 22,975,984 43,504 2012/03/04 09:20
1 5 32409 DB oper1 jprs @node1 (TNS V1-V3) 1,569,482 1,218,708 2,788,190 12,002 2012/03/04 09:20
1 56 8955 DB oper1 jprs @node1 (TNS V1-V3) 36,284 48,616 84,900 79,876 2012/03/04 09:20
1 153 6899 DB oper1 csmon @node1 (TNS V1-V3) 20,640 20,656 41,296 192 2012/03/04 09:20
1 640 20663 DB oper1 alarm @node1 (TNS V1-V3) 8,972 9,032 18,004 108 2012/03/04 09:20
1 201 979 DB oper1 idm@node1 (TNS V1-V3) 1,414 1,868 3,282 18 2012/03/04 09:20
1 255 30903 DB oper1 idm@node1 (TNS V1-V3) 1,120 36 1,156 2,490 2012/03/04 09:20
1 300 357 DB oper1 nuc_cmd@node1 (TNS V1-V3) 226 314 540 8 2012/03/04 09:20
1 251 2569 DB oper1 idm@node1 (TNS V1-V3) 232 228 460 44 2012/03/04 09:20
1 303 37635 DB oper1 nplex @node1 (TNS V1-V3) 164 148 312 12 2012/03/04 09:20
1 740 231 DB oper1 alarm @node1 (TNS V1-V3) 164 148 312 8 2012/03/04 09:20
1 204 38227 DB oper1 modcoms @node1 (TNS V1-V3) 164 148 312 8 2012/03/04 09:20
1 155 979 DB oper1 idm@node1 (TNS V1-V3) 80 72 152 8 2012/03/04 09:20
1 446 397 DB oper1 ssee @node1 (TNS V1-V3) 80 72 152 8 2012/03/04 09:20
1 349 147 DB oper1 nuc _cmd@node1 (TNS V1-V3) 80 72 152 0 2012/03/04 09:20
1 548 59523 DB oper1 nplex @node1 (TNS V1-V3) 48 42 90 2 2012/03/04 09:20
1 103 679 DB oper1 idm@node1 (TNS V1-V3) 40 36 76 4 2012/03/04 09:20
1 4 15199 DB oper1 idm@node1 (TNS V1-V3) 40 36 76 2 2012/03/04 09:20
1 104 46385 DB oper1 modcoms @node1 (TNS V1-V3) 40 36 76 0 2012/03/04 09:20
2 694 10289 DB oper1 ssee @node1 (TNS V1-V3) 58,880 66,376 125,256 1,488 2012/03/04 09:20
2 499 56441 DB oper1 ssee @node1 (TNS V1-V3) 44,084 35,290 79,374 148 2012/03/04 09:20
2 693 46753 DB oper1 isif @node1 (TNS V1-V3) 2,388 2,372 4,760 44 2012/03/04 09:20
2 737 945 DB oper1 isif @node1 (TNS V1-V3) 3,588 76 3,664 34,328 2012/03/04 09:20
2 741 15157 DB oper1 isif @node1 (TNS V1-V3) 224 224 448 92 2012/03/04 09:20
2 303 26405 DB oper1 isif @node1 (TNS V1-V3) 164 148 312 12 2012/03/04 09:20
2 740 38145 DB oper1 jp @node1 (TNS V1-V3) 164 148 312 8 2012/03/04 09:20
2 204 16585 DB oper1 nuc @node1 (TNS V1-V3) 164 148 312 8 2012/03/04 09:20
2 545 3011 DB oper1 isif @node1 (TNS V1-V3) 170 36 206 4,326 2012/03/04 09:20
2 57 9429 DB oper1 nuc @node1 (TNS V1-V3) 84 90 174 396 2012/03/04 09:20
2 643 801 DB oper1 ssee @node1 (TNS V1-V3) 80 72 152 8 2012/03/04 09:20
2 6 207 DB oper1 isif @node1 (TNS V1-V3) 42 40 82 2 2012/03/04 09:20
2 7 6923 DB oper1 csmon @node1 (TNS V1-V3) 42 38 80 2 2012/03/04 09:20
2 596 14615 DB oper1 ssee @node1 (TNS V1-V3) 40 36 76 2 2012/03/04 09:20



I have some doubts:

1) One of the two nodes have more load than the other, im trying to know what type of load balancing are we using, but can't find any information about it (only that exists 3 , for load, for session and random)
i check my PREFER_LEAST_LOADED_NODE_ and it's not configured ( i can't see anything with "show parameter PREFER_LEAST_LOADED_NODE_ "), our tnsnames are:

*DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sc.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB)
)
)

STANDBY_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dt)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB)
)
)

DB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2_sc)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB)
(INSTANCE_NAME = DB2)
)
)

DB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1_sc)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB)
(INSTANCE_NAME = DB1)
)
)*



I must supposed that we are using load balancing?

2) Could it be mixed the 3 types? how?


thanks for support and your time.

* i promise that i tabulated the script, but don't know what happened :S