*** NOTES 19/06/2017 12:46:10 sa Action Type: PM Team
AutoClarify Fault Raised By OMNIBUS User cwhpopsdba
==================================================
GAS Link : http://omnihist2.nat.bt.com/cgi-bin/alarmmis/new/gas3.pl?action=Lookup&help_tag=GASTAG:NOGASID&project=BTPSCRMHELPDESK&class=&nodealias=blp07768023&summary=Database%20Entity%20Failed:%20APP07768%20AUTOCLARIFY:DBAORA2L:3%20~%20EMGC-EM00078%20hrcath1%20CRIT%20Database_Instance%20Database_Limits%20~%20Metrics%20Process%20Limit%20%%20is%20at%2091%20
Event ID:     750446762
PROJECT:    BTPSCRMHELPDESK
APPLICATION:  HR Helpdesk
APPID:     APP07768
HELP:       GASTAG:NOGASID
NODE:       blp07768023
IP ADDRESS: 10.52.136.134
PROBE:      trapd from hws000a005
SITE:       Reigate Data Centre,Chesterfield Park,Buckland Road,Reigate,SURREY,RH2 9TB
BUILDING:   HQL-UB
SKYLINE:    RH0008A1
TALLY:      2
FIRST:      19/06/17,12:42
LAST:       19/06/17,12:42
SUBPROJECT: SPSERV,SPAPP,SPCOMP
SUMMARY:    Database Entity Failed: APP07768 AUTOCLARIFY:DBAORA2L:3 ~ EMGC-EM00078 hrcath1 CRIT Database_Instance Database_Limits ~ Metrics Process Limit % is at 91




*** RESEARCH LOG 19/06/2017 13:25:16 slnxk36 Action Type: Action Taken
*** Master CWHPOPSDBA        Noman Khan  07877 766 748  slnxk36
looking for log
################
RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------------------------ ------------------- --------------- ----------------------------------------
processes                                      366             371        400>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>to high
sessions                                       384             392        624
   


*** RESEARCH LOG 19/06/2017 13:27:38 slnxk36 Action Type: Action Taken
*** Master CWHPOPSDBA        Noman Khan  07877 766 748  slnxk36
Inactive session
###########
USERNAME                       STATUS     COUNT(*)
------------------------------ -------- ----------
PAYROLL                                       INACTIVE          4
CA_CWK_CONVERSION              INACTIVE          6
TREASURY                                   INACTIVE          6
ARK_USER                                   INACTIVE          6
OSDK_HISTORY                           INACTIVE          6
CA_COMMON_SCHEMA               INACTIVE          6
PEN_DOCUMENTUM                    INACTIVE          8
OSDK_LANDING                           INACTIVE         10
CA_CONTINGENT_WORKERS      INACTIVE         16
ABSENCE_LEAVE                            INACTIVE         48
CA_HEALTH_AND_SAFETY           INACTIVE         60
CA_CONTRACTS_AUTOMATION   INACTIVE         62
CA_PAID_LEAVERS                        INACTIVE        180
CA_EXECUTIVE_SHARES            INACTIVE        186


*** RESEARCH LOG 19/06/2017 13:36:21 slnxk36 Action Type: Action Taken
*** Master CWHPOPSDBA        Noman Khan  07877 766 748  slnxk36
high number of inactive session so passing back to ASg please recycle your application server
########
 ***  Changed to Priority  5  at 27/07/2017 10:05:07  *** nurqk00 : reducing to p5  as it is non-prod server and no service impact to prod