ostat_mem.sql

--conn / as sysdba

set serveroutput on
col output format a210
set arraysize 1

select * from table( sys.pipe_ostat.pipe_xdiff('
select name		,'''' display_name	,value	,''YES'' show	,''YES'' cumulative	,'''' formula 					from V$SYSSTAT where name like ''%mem%'' and name not like ''%IM %'' and name not like ''xmem%'' and name not like ''index%'' and name not like ''%max''
',sample_cnt=>99999 ,SAMPLE_INTERVAL=>1 ,column_width=>14));