user9338712 wrote:select count(*) from v$session;
10.2.0.4 on Solaris 10
Very often we have huge number of sessions in the database, if left unnoticed, this sessions are degrading the performance of the database.
So, I need to monitor the sessions in the database, if the output of select * from gv$session goes more than 900, then an email as an alert need to be immediately sent to DBA Team (mail id).
Can Any one give me some pointers or hints to do the same. I don't need the full fledged solution, but some insight, from which I will develop the solution.