Difference between revisions of "RAC - Login Sessions"
From pressy's brainbackup
(Created page with "== RAC Login Sessions == How is your RAC session distribution on the nodes? <pre> SYS@ODB SQL> select inst_id,machine,count(*) from gv$session group by inst_id,machine order...") |
(→RAC Login Sessions) |
||
Line 8: | Line 8: | ||
INST_ID MACHINE COUNT(*) | INST_ID MACHINE COUNT(*) | ||
---------- ---------------------------------------------------------------- ---------- | ---------- ---------------------------------------------------------------- ---------- | ||
− | 1 cluster1c0l01z01a | + | 1 cluster1c0l01z01a 3 |
− | 1 serversapd | + | 1 serversapd 7 |
− | 1 serversapf | + | 1 serversapf 2 |
− | 1 serversape | + | 1 serversape 3 |
− | 1 cluster2c0l01z03a | + | 1 cluster2c0l01z03a 13 |
− | 1 cluster1c0l01z01a | + | 1 cluster1c0l01z01a 98 |
− | 1 serversapa | + | 1 serversapa 9 |
− | 1 blavoem11 | + | 1 blavoem11 8 |
− | 1 serversap5 | + | 1 serversap5 1 |
− | 1 serversapb | + | 1 serversapb 1 |
− | 1 serversapc | + | 1 serversapc 9 |
− | 1 blagtwp11 | + | 1 blagtwp11 3 |
− | 1 svszap01 | + | 1 svszap01 70 |
− | 1 svszmg04 | + | 1 svszmg04 1 |
− | 2 cluster1c1l01z01a | + | 2 cluster1c1l01z01a 110 |
− | 2 cluster1c0l01z01a | + | 2 cluster1c0l01z01a 1 |
− | 2 serversapc | + | 2 serversapc 239 |
− | 2 svszmg04 | + | 2 svszmg04 1 |
− | 2 serversapd | + | 2 serversapd 255 |
− | 2 serversap5 | + | 2 serversap5 246 |
− | 2 serversape | + | 2 serversape 264 |
− | 2 cluster1c1l01z01a | + | 2 cluster1c1l01z01a 4 |
− | 2 serversapf | + | 2 serversapf 258 |
− | 2 svszap01 | + | 2 svszap01 84 |
25 rows selected. | 25 rows selected. |
Latest revision as of 09:00, 30 April 2018
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>