Session count Alert ( get mail more than 90 sessions were opened )

Description:

Script for more Session count Alert ( get mail more than 90 sessions were opened )

Steps:

select to_char(sysdate,’dd-mm-yy:HH:MM:SS’) from dual;
set feedback off
set serveroutput on
—
spool /home/prddbsmgr/scripts/count_session.log
declare

count_sess number(12);
val number(12);
s_pct number(6,3);

begin

select count(*) into count_sess from v$session;

select value into val from v$parameter where name = ‘processes’;

s_pct := (count_sess / val) * 100;

if s_pct > 90 then

dbms_output.put_line (count_sess||’are running’ );

end if;

end;
/
spool off;
exit;