Historic session count originated from different machine for a user
Hi expert ,
There is a schema called PC_OWNER used by the application X , and the application is deployed in multiple machine and I could able to get the number of sessions originated from each machine using below query
SQL> select INST_ID,MACHINE ,count(1) count from gv$session where schemaname='PC_OWNER' group by INST_ID,MACHINE ;
INST_ID MACHINE COUNT
---------- ------------------------------------------------ ----------
2 vpl00001829.machine.tst 125
2 vpl00001696.machine.tst 128
2 vpl00001694.machine.tst 123
2 vpl00001695.machine.tst 172
2 vpl00001828.machine.tst 123
2 vpl00001697.machine.tst 129
6 rows selected.
Now application team want to know the simliar metrics for the last one month , they need output in below format