title: Inactive sessions in Oracle
body: <p>I would like to ask a question :</p>
  
  <p>This is my environment :</p>
  
  <ul>
  <li>Solaris Version 10;  Sun OS Version 5.10</li>
  <li>Oracle Version: 11g Enterprise x64 Edition.</li>
  </ul>
  
  <p>When I am running this query :</p>
  
  <pre><code>select c.owner, c.object_name, c.object_type,b.sid, b.serial#, b.status, b.osuser, b.machine 
    from v$locked_object a , v$session b, dba_objects c 
   where b.sid = a.session_id 
    and a.object_id = c.object_id;
  </code></pre>
  
  <p>Sometimes I get many status to be <code>'INACTIVE'</code>. </p>
  
  <p>What does this inactive mean?
  Does this will make my db and application slow?
  What are the affects of active and inactive status?</p>