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>