How to list active / open connections in Oracle? October 21, 2022 by Tarik Use the V$SESSION view. V$SESSION displays session information for each current session.