How to list active / open connections in Oracle? -

Is there a hidden table, a system variable, or to show an active connection at a given moment?

Use the scene.

displays the session information for the V $ session each current session.