title: How to check the log of users and applications connected to the oracle database?
body: <p>I need to check what are the applications that are connected to the oracle database.
  For that I have tried this:</p>
  
  <pre><code>SELECT username, machine, program
  FROM v$session
  WHERE type = 'USER';
  </code></pre>
  
  <p>This shows the database user, system login and application, but it is showing only currently connected connections.
  I want to see complete log. </p>
  
  <p>Any help would be appreciated.</p>