Sometimes the number of sessions on database are close to 500 normally total number of sessions are between 20 to 40. Total number of sessions increase all of sudden and come back to normal within 5 mins. Our application (Siebel CRM) does not respond well during this time and also CPU utilization spikes to 90-100%. I want to find out what is causing sessions spike and sudden slowness.
Is there any resolution.