How to list active open connections in Oracle

Question

Is there any hidden table  system variable or something to show active connections in a given moment

User · Accepted Answer

Use the V SESSION view      V SESSION displays session information for each current session

User · Answer

Select count 1  From V session where status  ACTIVE

User · Answer

The following gives you list of operating system users sorted by number of connections  which is useful when looking for excessive resource usage   select osuser  count    as active conn count  from v session  group by osuser  order by active conn count desc

User · Answer

select   username    osuser    terminal    utl inaddr get host address terminal  IP ADDRESS from   v session where   username is not null order by   username    osuser

User · Answer

select status  count 1  as connectionCount from V SESSION group by status

User · Answer

When I d like to view incoming connections from our application servers to the database I use the following command   SELECT username FROM v session  WHERE username IS NOT NULL  ORDER BY username ASC    Simple  but effective

User · Answer

select      count 1   NO  Of DB Users        to char sysdate  DD-MON-YYYY HH24 MI SS   sys time from      v session  where      username is NOT  NULL

User · Answer

select s sid as  Sid   s serial  as  Serial    nvl s username       as  Username   s machine as  Machine   s schemaname as  Schema name   s logon time as  Login time   s program as  Program   s osuser as  Os user   s status as  Status   nvl s process       as  OS Process id  from v session s where nvl s username   a   not like  a  and status like  ACTIVE  order by 1 2   This query attempts to filter out all background processes

User · Answer

For a more complete answer see     http   dbaforums org oracle index php showtopic 16834  select        substr a spid 1 9  pid         substr b sid 1 5  sid         substr b serial  1 5  ser          substr b machine 1 6  box         substr b username 1 10  username  --       b server         substr b osuser 1 8  os user         substr b program 1 30  program from v session b  v process a where b paddr   a addr and type  USER  order by spid

[oracle] How to list active / open connections in Oracle?

Examples related to oracle