1 2 Previous Next 19 Replies Latest reply on Dec 21, 2015 5:53 AM by IT-HILLS

    Large Number of INACTIVE sessions in Oracle EBS (12c)

    IT-HILLS

      Hi team,

       

      We are using Oracle 12c (EBS) database, it having more number of inactive sessions for everyday. please suggest me can i proceed to kill that all inactive sessions..

      and give some idea to find out what going on my database for this issue.

      please refer this... need more info please find the attachments.

       

      USERNAMEOSUSERSIDSERIAL#SPIDLOCKWAITSTATUSMODULEMACHINEPROGRAMLOGON_TIME
      APPLSYSPUBapplmgr804729176
      INACTIVEJDBC Thin ClientshivamJDBC Thin Client12-DEC-2015 23:04:38
      APPLSYSPUBapplmgr106129178
      INACTIVEJDBC Thin ClientshivamJDBC Thin Client12-DEC-2015 23:04:38
      APPLSYSPUBapplmgr45413129246
      INACTIVEJDBC Thin ClientshivamJDBC Thin Client12-DEC-2015 23:04:41
      APPLSYSPUBapplmgr157129182
      INACTIVEJDBC Thin ClientshivamJDBC Thin Client12-DEC-2015 23:04:38
      APPLSYSPUBapplmgr1305529180
      INACTIVEJDBC Thin ClientshivamJDBC Thin Client12-DEC-2015 23:04:38
      APPSapplmgr1761529007
      INACTIVEe::cp:30shivamICM@shivam (TNS V1-V3)12-DEC-2015 23:04:04
      APPSapplmgr2363,83927639
      INACTIVEe:INV:cp:INVMGRshivamINVMGR@shivam (TNS V1-V3)15-DEC-2015 07:36:48
      APPSapplmgr2705,37729667
      INACTIVEe:FND:cp:STANDARDshivamSTANDARD@shivam (TNS V1-V3)15-DEC-2015 09:07:03
      APPSapplmgr3021329052
      INACTIVEFNDSM@shivam (TNS V1-V3)shivamFNDSM@shivam (TNS V1-V3)12-DEC-2015 23:04:36
      APPSapplmgr32748328697
      INACTIVEe:FND:cp:STANDARDshivamSTANDARD@shivam (TNS V1-V3)15-DEC-2015 08:29:29
      APPSapplmgr38340,41729914
      INACTIVEe:INV:cp:INVMGRshivamINVMGR@shivam (TNS V1-V3)15-DEC-2015 09:15:50
      APPSapplmgr5291,20329794
      INACTIVEe:INV:cp:INVMGRshivamINVMGR@shivam (TNS V1-V3)15-DEC-2015 09:11:52
      APPSapplmgr7839330034
      INACTIVEe:INV:cp:INVMGRshivamINVMGR@shivam (TNS V1-V3)15-DEC-2015 09:20:42
      APPSapplmgr1299,16529776
      INACTIVEe:FND:cp:STANDARDshivamSTANDARD@shivam (TNS V1-V3)15-DEC-2015 09:11:33
      APPSapplmgr1896,13329991
      INACTIVEe:FND:cp:STANDARDshivamSTANDARD@shivam (TNS V1-V3)15-DEC-2015 09:19:04
      APPSapplmgr2084,91721254
      INACTIVEe:INV:cp:INVMGRshivamINVMGR@shivam (TNS V1-V3)15-DEC-2015 02:34:52
      APPSapplmgr23191921825
      INACTIVEe:INV:cp:INVMGRshivamINVMGR@shivam (TNS V1-V3)15-DEC-2015 03:04:52
      APPSapplmgr25374928955
      INACTIVEe:FND:cp:STANDARDshivamSTANDARD@shivam (TNS V1-V3)15-DEC-2015 08:40:30
      APPSapplmgr3085,98129669
      INACTIVEe:FND:cp:STANDARDshivamSTANDARD@shivam (TNS V1-V3)15-DEC-2015 09:07:03
        • 1. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)

          The only problem exists between keyboard and chair.

           

          Anything you do to the INACTIVE session will cause more damage than ignoring them.

           

          When you are connected to any Oracle database & thinking about what to do next your session is INACTIVE.

          Would you find it acceptable for your session to be terminated because it was INACTIVE?

          1 person found this helpful
          • 2. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
            JuanM

            Hi,

            Having INACTIVE sessions in Oracle database is normal.

             

            This status indicates that your sessions are not doing anything at that moment. You can check the column LAST_CALL_ET in v$session to see how much time the sessions are doing nothing, if the time is too much, then you can kill those ones, kill process is very good explained here thanks to Tim Hall

            https://oracle-base.com/articles/misc/killing-oracle-sessions

             

            Here in this forums there are many threads where you can see how to implement a job process via scheduler  that kills inactive or snipped sessions or using Oracle resource manager.

             

            But, instead to trying to identify why there are to many sessions, try to find what application is establishing many sessions without using them. This behavior is not related with Oracle, it is 100% related to bad configured connection pooling or excessive connections from apps.

             

            Regards,

            Juan M

            1 person found this helpful
            • 3. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
              IT-HILLS

              Hi,

               

              thanks for the update.... the inactive sessions make any problem in my database.

              i have killed some of sessions but it will affect the alert log. and the  alert log getting some errors and warnings.

               

              Regards,

              Jayan V.

              • 4. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                Pavan Kumar

                SHANTHI SOCIAL SERVICES COIMBATORE wrote:

                 

                Hi,

                 

                thanks for the update.... the inactive sessions make any problem in my database.

                i have killed some of sessions but it will affect the alert log. and the  alert log getting some errors and warnings.

                 

                Regards,

                Jayan V.

                1. Please don't try to kill as per your need as you see inactive. Since their is no reason it would be hammering your database.

                2. Please try to investigate- which process is connection from client - either from concurrent server or forms server and different node. Verify module/program/service.. based on those investigations if its sessions some one left over then you can take action. Please investigate and investigate that is your job role (don't be in  hurry)

                 

                - Pavan Kumar N

                1 person found this helpful
                • 5. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                  Hemant K Chitale

                  The top 5 in your list may be user sessions.  The rest of them are Internal and other Concurrent Managers which should not be killed.  (Do you know what Concurrent Managers are when you run EBusiness Suite ?  If not, please look up the documentation)

                   

                  The status INACTIVE may be so at the instant in time you query. The session may be ACTIVE 2seconds or 5seconds or 5minutes or 1hour later.  What rule of thumb would you use to determine whether a (currently INACTIVE) session should be killed ?

                   

                  It is true that some applications have behaviour where the application doesn't use an existing session but leaves it "hanging" and INACTIVE for a long time but keeps opening new sessions.  Such applications may need cleanup of INACTIVE sessions.  EBusiness Suite is not such an application (except for the rare hanging session for a user who may have abnormally disconnected).

                   

                   

                  Hemant K Chitale

                  • 6. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                    Srini Chavali-Oracle

                    ..please suggest me can i proceed to kill that all inactive sessions..

                    No - do not kill inactive session in any database.

                     

                    ..and give some idea to find out what going on my database for this issue.

                    Pl elaborate on what "this issue" is.

                    • 7. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                      Hussein Sawwan-Oracle
                      thanks for the update.... the inactive sessions make any problem in my database.

                       

                      What kinds of problems/issues?

                       

                      Does this impact the performance?

                       

                      What's your application release? OS?

                       

                      For "JDBC Thin Client", please see (JDBC Connection Keep Growing With Majority of Connections Being Inactive (Doc ID 311933.1)).

                       

                      You can kill inactive sessions for inactive users (which is shown in your attached file) by referring to (How to Kill Inactive Sessions Based on the Information in the Monitor User Form (Doc ID 103516.1)).

                       

                      Thanks,

                      Hussein

                      • 8. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                        Bashar.

                        Hi,

                         

                        Are you running EBS 12.2?

                        If yes then what is your AD & TXK patch levels?

                         

                        Regards,

                        Bashar

                        • 9. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                          IT-HILLS

                          Hi

                           

                           

                          AD     R12.AD.B.3

                          there no patch for TXK

                          • 10. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                            Hussein Sawwan-Oracle

                            SHANTHI SOCIAL SERVICES COIMBATORE wrote:

                             

                            Hi

                             

                             

                            AD     R12.AD.B.3

                            there no patch for TXK

                             

                            Looks like you're on 12.1.x -- If you cannot provide basic details about your application release and/or patchset level then how do you expect us to help?

                             

                            Thanks,

                            Hussein

                            • 11. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                              IT-HILLS

                              Sorry..

                               

                              We are using Oracle EBS R12.(12.1.3)

                              and database

                               

                              BANNER                                                                                                       CON_ID

                              --------------------------------------------------------------------------------                                     -------------

                              Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production              0

                              PL/SQL Release 12.1.0.1.0 - Production                                                                    0

                              CORE    12.1.0.1.0      Production                                                                             0

                              TNS for Linux: Version 12.1.0.1.0 - Production                                                           0

                              NLSRTL Version 12.1.0.1.0 - Production                                                                    0

                              • 12. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                                IT-HILLS

                                Hi all,

                                 

                                every day am getting this level of INACTIVE sessions.

                                 

                                 

                                MACHINEACTIVEINACTIVEKILLED
                                SHANTHISOCIAL\SSDC-COCP-009010
                                SHANTHISOCIAL\SSDC-COCP-074010
                                SHANTHISOCIAL\SSDC-COCP-083100
                                SHANTHISOCIAL\SSDC-LT-003010
                                shivam191320
                                sss-cus-app020
                                sss-prd-db3800




                                 

                                Please suggest me what i do on this issue..

                                • 13. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)

                                  SHANTHI SOCIAL SERVICES COIMBATORE wrote:

                                   

                                  Hi all,

                                   

                                  every day am getting this level of INACTIVE sessions.

                                   

                                   

                                  MACHINE ACTIVE INACTIVE KILLED
                                  SHANTHISOCIAL\SSDC-COCP-009 0 1 0
                                  SHANTHISOCIAL\SSDC-COCP-074 0 1 0
                                  SHANTHISOCIAL\SSDC-COCP-083 1 0 0
                                  SHANTHISOCIAL\SSDC-LT-003 0 1 0
                                  shivam 19 132 0
                                  sss-cus-app 0 2 0
                                  sss-prd-db 38 0 0




                                   

                                  Please suggest me what i do on this issue..

                                  ISSUE?

                                  The only issue exists between your two ears.

                                  Problems are reported with error codes & messages.

                                  Please go focus on real problems or just mellow out& have a cup of tea.

                                  • 14. Re: Large Number of INACTIVE sessions in Oracle EBS (12c)
                                    Pavan Kumar

                                    Hi,

                                     

                                    1. why are you for some thing.

                                    2. Ping to person who is owner of the server and check what things he is carrying out.

                                     

                                    - Pavan Kumar N

                                    1 2 Previous Next