Why are my Oracle sessions INACTIVE?

October 28, 2015 KJL

Hello Oracle users!

 

Have you ever looked at the view v$session to see how many Maximo sessions are open for your application? 

And then wonder why they all display as INACTIVE?

 

(You will need DBA privilege or read privilege on the view v$session to select the results.)

 

This SQL statement can be run to view the open sessions for the MAXIMO schema.

 

select sid, status, machine, program, username, logon_time, last_call_et
from v$session                                 
where schemaname = 'MAXIMO';

 

This is how one of the records will appear.

 

SID STATUS      PROGRAM             MACHINE   USERNAME      LOGON_TIME      LAST_CALL_ET
  21 INACTIVE   JDBC Thin Client    MAXEAM    MAXIMO            28-oct-2015 18:03                         3 

 

You will see that all (or almost all) of the sessions are INACTIVE!

This is how Oracle works.  The only sessions which will have a status of ACTIVE are those which are using the CPU to execute a SQL statement.

If you are merely connected to Oracle, your session will be INACTIVE.

 

Hope that helps!

           

Previous Article
New SERVERSESSION table in Maximo Asset Management 7.6
New SERVERSESSION table in Maximo Asset Management 7.6

Hey guys! This will be my first blog about Maximo Asset Management and just to give you a heads up, there w...

Next Article
My Collection of Automation Scripts

G'Day! Do you want to put in little enhancements in your system without having to learn to code first? Some...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!