IBM Support

Why are my Oracle sessions INACTIVE?

Technical Blog Post


Abstract

Why are my Oracle sessions INACTIVE?

Body

Looking at the view v$session to see how many Maximo sessions are open for your application, do you wonder why they all display as INACTIVE?

This SQL statement can be run to view the open sessions for the MAXIMO schema. You need DBA privilege or read privilege on the view v$session to select the results.

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

This is how one of the records appears.

SID |STATUS  |MACHINE     |PROGRAM              |USERNAME|LOGON_TIME             |LAST_CALL_ET|
----+--------+------------+---------------------+--------+-----------------------+------------+
5283|INACTIVE|cakes1      |JDBC Thin Client     |MAXIMO  |2023-01-31 06:29:43.000|          51|

You will see all, or almost all, of the sessions are INACTIVE! Why? It is how Oracle works. The only sessions that have ACTIVE status are using the CPU to execute an SQL statement. If you are connected to Oracle with a browser to Maximo, but not performing any actions in that browser, your session is INACTIVE.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11131741