RAC - Login Sessions
From pressy's brainbackup
RAC Login Sessions
How is your RAC session distribution on the nodes?
SYS@ODB SQL> select inst_id,machine,count(*) from gv$session group by inst_id,machine order by inst_id;
INST_ID MACHINE COUNT(*)
---------- ---------------------------------------------------------------- ----------
1 cluster1c0l01z01a 3
1 serversapd 7
1 serversapf 2
1 serversape 3
1 cluster2c0l01z03a 13
1 cluster1c0l01z01a 98
1 serversapa 9
1 blavoem11 8
1 serversap5 1
1 serversapb 1
1 serversapc 9
1 blagtwp11 3
1 svszap01 70
1 svszmg04 1
2 cluster1c1l01z01a 110
2 cluster1c0l01z01a 1
2 serversapc 239
2 svszmg04 1
2 serversapd 255
2 serversap5 246
2 serversape 264
2 cluster1c1l01z01a 4
2 serversapf 258
2 svszap01 84
25 rows selected.
SYS@ODB SQL>
SYS@ODB SQL> select inst_id,user,count(*) from gv$session group by inst_id,user order by inst_id;
INST_ID USER COUNT(*)
---------- ------------------------------ ----------
1 SYS 226
2 SYS 1439
SYS@ODB SQL>