-- block changes per sec happening in the Oracle database
declare
v_blockchg number;
begin
select value
into v_blockchg
from v$sysstat
where name='db block changes';
dbms_lock.sleep(60);
select (value-v_blockchg)/60
into v_blockchg
from v$sysstat
where name='db block changes';
dbms_output.put_line('block changes per sec = '||round(v_blockchg,2));
end;
/
Output :
Tags:
Oracle