IV68045: LONG RUNNING CONNECTIONS NOT CLOSING INACTIVE GV$SESSION

APAR status

• Closed as program error.

Error description

• Maximo's DBManager class which handles user's  session does not
  consider looking at GV$SESSION when killing  long running
  connections, instead only looks at V$SESSION.
  
  STEPS TO REPRODUCE:
  --------------------------
  Our customers use Oracle RAC as their distributed database and
  per the RAC's architecture, all the RAC participant users
  information is stored in GV$SESSION which has a special column
  INST_ID (Instance ID) which refers to the instance number from
  which the information comes from.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Maximo Usres                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Long running connections not closing inactive gv$session.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to latest release.                                   *
  ****************************************************************
  Maximo's DBManager class which handles user's session does not
  consider looking at GV$SESSION when killing long running
  connections, instead only looks at V$SESSION.
  
  STEPS TO REPRODUCE:
  --------------------------
  Our customers use Oracle RAC as their distributed database and
  per the RAC's architecture, all the RAC participant users
  information is stored in GV$SESSION which has a special column
  INST_ID (Instance ID) which refers to the instance number from
  which the information comes from.
  

Problem conclusion

• The gv$session table is used to check for long running
  connections for Oracle Real Application Cluster.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Fix Pack Release 7.5.0.8 TPAE
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels