Need a query to go against v$active _session_history to calculate the current active sessions, so that we can alert on it..
I have attached a screen shot of the time period between Feb 3rd 9pm to Feb 4th 12 am, which shows a spike of about 310 active sessions.
The first screen shot shows about 300 + active sessions and second screen shot shows that there are only 4 o5 active sessions.
I need a query that will show me that value of 300+ active sessions that occurred the day before..
Can you please help? -3DFF9851DD9A1B32.bmp -2E62494C4F96C6.bmp