监控session process存储过程

DECLARE
 v_lower NUMBER :=1;
 v_upper NUMBER :=1000000;

BEGIN
   FOR i IN v_lower .. v_upper LOOP
     DBMS_LOCK.SLEEP(1);
   insert into sp
   select (select count(0) from v$session) s,(select count(0) from v$process) p,sysdate d  from dual;
   commit;
   END LOOP;

END;

/