gv$sql + gv$session

Hello All,

I am using a below query to monitor which is on version : 12.2.0.1.0 and RAC.But somehow the results seems to be a bit diff when compared with results of 'monitor sessions'

in sql developer especially the number of sessions for specific module.

Please let me know if there needs to be any modification on the way the query is formed.

SELECT s.inst_id inst_id,

       s.sid sid,

       s.serial# serial#,

       to_char(s.LOGON_TIME,'YYYY-MM-DD HH24:MI:SS') "LOGON_TIME",

       a.module                  module,

       a.action                  action,

       s.username                username,

       TO_CHAR(a.last_active_time, 'YYYY-MM-DD/hh24:mi:ss') last_active_time,