ostat_test.sql

set head on
select distinct decode(class,
1,'  1 - User',
2,'  2/34 - Redo',
34,'  2/34 - Redo',
4,'  4 - Enqueue',
8,'  8 - Cache/IO',
16,' 16 - OS',
32,' 32/33 - Real Application Clusters',
33,' 32/33 - Real Application Clusters',
40,' 40 - gc/fusion',
64,' 64 - SQL/OLAP/cell/table/index',
72,' 72 - Batched IO/buffer',
128,'128 - IM/IMU/EHCC/BA/securefile/index/Headmap/redo/CLI/KTFB/segment/HSC OLTP/cell/queue/transaction/SMON/...',
class) class,count(*) 
from v$sysstat
group by class
;


set serveroutput on
col output format a200
set arraysize 1

/*
--exec DBMS_DEBUG_JDWP.CONNECT_TCP( 'your_host_ip', 4000 );

--value in v$sys_time_model: us; in v$sysstat: cs
--
select * from table( pipe_ostat.pipe_xdiff('
select name		,'''' display_name	,value	,''YES'' show	,''YES'' cumulative	,'''' formula 					from V$SYSSTAT where 
name in (
''redo size'',
''redo wastage'',
''redo entries'',
''redo blocks written'',
''redo writes'',
''redo write time'',
''redo synch time'',
''redo sync writes'',
''redo write size count (   4KB)'',
''redo write size count (   8KB)'',
''redo write size count (  16KB)'',
''redo write size count (  32KB)'',
''redo write size count (  64KB)'',
''redo write size count ( 128KB)'',
''redo write size count ( 256KB)'',
''redo write size count ( 512KB)'',
''redo write size count (1024KB)'',
''redo write size count (inf)'',
''redo write worker delay (usec)'',
''redo writes adaptive all'',
''redo writes adaptive worker'')
'
,sample_cnt=>99999
,SAMPLE_INTERVAL=>1
,column_width=>8
,debug=>0
));  
  
*/