RAC - Login Sessions

From pressy's brainbackup
Jump to: navigation, search

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>