A relational database management system is the Oracle database. OracleDB, or just Oracle, is another name for it. Oracle Corporation creates and markets it. It is one of the most used relational database engines for storing, organizing, and retrieving data in the IT sector.
Sessions that are operating for a longer period in an Oracle database can be observed using the v$session_longops view supplied by Oracle. Make careful to use gv$session_longops instead of v$ for RAC.
Active sessions – count
SQL> select count(s.status)
2 from gv$session s, v$process p
3 where
4 p.addr=s.paddr and
5 s.status=’ACTIVE’;
Posted from: https://oracledbwr.com/check-oracle-active-and-inactive-sessions/
Other links: https://www.iheavy.com/how-to-check-active-sessions-in-oracle-database/