Location-Based Situation:  CRITICAL:  Please see Log tab for full information. Multiple alerts affecting site : 1003 ROUTE 202 NORTH <INC>  
system is up and running, 
 
 
•	Application Team, Network Security Team, ISRM , SAP Basis teams are in attendance 
•	Network team is doing the trace analysis currently 
•	Similar performance issues observed in QA environment 
•	Remediation steps narrowed down to SQL statement involving LIPS and VBAK tables taking high CPU time to process 
•	STAT collection on the above 2 tables followed by index rebuild on their primary index produced desired results in QA 
•	Discussion with business on Similar activity to be carried out in production for resolving the issue 
•	Business has given time at 7 PM CET to start the activity in the PROD environment (P01). 
•	The proposed steps for did not work for production , high critical oss ticket raised with SAP and de-escalation architect has joined our GCC call. 
•	System P01 is now being brought down for applying a fix control bug fix for oracle 19.28 patch version for inner join ( problem statement sql) as per recommendation from sap note: 3678186. After restart testing will resume. 
•	Issue has been resolved after updating database parameters as per SAP along with complete restart of P01. 
