Database Administration (MOSC)

MOSC Banner

Historic session count originated from different machine for a user

edited Aug 23, 2020 5:03AM in Database Administration (MOSC) 1 commentAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center