SQL> col name format a30
SQL> col value format 999,999,999,999,999
SQL>
SQL> -- 1. 1st snapshot
SQL> col value new_value prev_value
SQL> select name, value
2 from v$sysstat
3 where name = 'session logical reads';
NAME VALUE
------------------------------ --------------------
session logical reads 443,353
SQL>
SQL> -- 1-1. save 1st snapshot
SQL> prompt &prev_value
443353
SQL>
SQL> -- 2. Workload Process
SQL> select count(*) from all_objects ;
COUNT(*)
----------
45980
SQL>
SQL>
SQL> -- 3. 2nd snapshot
SQL> col value new_value next_value
SQL> select name, value
2 from v$sysstat
3 where name = 'session logical reads';
NAME VALUE
------------------------------ --------------------
session logical reads 516,860
SQL>
SQL> -- 3-1. save 2nd snapshot
SQL> prompt &next_value
516860
SQL>
SQL> -- 4. Diff Report
SQL> select (&next_value - &prev_value) as diff from dual ;
구 1: select (&next_value - &prev_value) as diff from dual
신 1: select ( 516860 - 443353) as diff from dual
DIFF
----------
73507