title: Oracle session and process increasing
body: <p>so I have oracle 12c installed in cantos, the RAM 96GB and the disk are SSD which is pretty fast, and also an application is running on the same server with a lot of conversion and processing of the data.</p>
  
  <p>this was pretty much new system that I installed database and application on it, so after couple of hours I see it give error of </p>
  
  <p><strong>"got minus one from a read call"</strong></p>
  
  <p>after digging around I see it was the session and process causing it so in increase that, but still after 24 hours I see the processes and session increasing it does not decrease when checking... bellow is the snap shot of the query during couple of hours I did.</p>
  
  <pre><code>select program,username,status,schemaname,count(*) from v$session
  
  group by username,status,osuser,schemaname,program
  
  order by count(*) desc,status
  
  fetch first 3 rows only
  </code></pre>
  
  <blockquote>
    <p>2:00 PM 11 December</p>
    
    <p>JDBC Thin Client                oracleuser INACTIVE             schemeName 233</p>
    
    <p>SQL Developer  SYS         INACTIVE             SYS         4</p>
    
    <p>JDBC Thin Client                oracleuser ACTIVE schemeName 3</p>
  </blockquote>
  
  <pre><code>select * from v$resource_limit where resource_name in ('processes','sessions');
  </code></pre>
  
  <blockquote>
    <p>6:55 PM 11 December</p>
    
    <p>processes            490         492               1200       1200 0</p>
    
    <p>sessions               500         504               1920       1920 0</p>
  </blockquote>
  
  <p>After I observe it that it keep increasing I changed the idle_time in user profile to be 30 minute</p>
  
  <blockquote>
    <p>IDLE_TIME          30</p>
    
    <p>CONNECT_TIME               UNLIMITED</p>
  </blockquote>
  
  <p>after that I observe them for couple of more hours and run same query above and here is the results respectively.</p>
  
  <blockquote>
    <p>8:25 PM 11 December</p>
    
    <p>JDBC Thin Client                oracleUser KILLED   schemename 683</p>
    
    <p>JDBC Thin Client                oracleuser INACTIVE<br>
    schemeName 241</p>
    
    <p>SQL Developer  SYS         INACTIVE             SYS         4</p>
  </blockquote>
  
  <pre><code>8:25 AM 12 December
  
  processes            995         998               1200       1200 0
  
  sessions               1003       1007             1920       1920 0
  </code></pre>
  
  <p>NOW I see killed session and less inactive session, but they number of session keep increasing it does not drop I was expecting that changing idle_time in profile will kill inactive session and release the session and processes.</p>
  
  <p>my concern is that when the session and processes hit the limit I set, I will getting again the same <strong>minus one error</strong> . and it will kill application also.</p>
  
  <p>"got minus one from a read call"</p>
  
  <p>any help will be highly  appreciated </p>
  
  <p>regards</p>