DB version: 11.2.0.4
OS : Oracle Linux 6.4
Occasionally, one of my applications goes berserk and start spawning lots of DB sessions and eventually the DB will become slow. Then I start killing sessions which are old and INACTIVE to fix the issue.
Today, application team is reporting that the DB is slow and I can see the following session count. I am not sure if these session counts are healthy. Is there a way I could check what the instance counts were yesterday around the same time (SYSDATE-1) ? The DB (and the application) was healthy yesterday.
PROCESSES parameter set to 2500
| select | inst_id, count(*) |
| from | gv$session |
| where | type='USER' group by inst_id |
order by count(*) desc;
INST_ID COUNT(*)
---------- ----------
1 1354
2 1235
3 1214