column sname format a30
column pname format a30
column pval1 format 999999999999
column pval2 format a30

PROMPT ----NOWORKLOAD STATS-----

PROMPT CPUSPEEDNW: Shows the nowrokload CPU speed, in terms of the average number of CPU cycles per second
PROMPT IOSEEKTIM: The sum of seek time, latency time, and OS overhead time
PROMPT IOTFRSPEED: Stands for I/O transfer speed and tells the optimizer how fast the database can read data in a single read request

select sname,pname,pval1,pval2 from SYS.AUX_STATS$ 
where pname in ('DSTOP','DSTART','STATUS','CPUSPEEDNW','IOSEEKTIM','IOTFRSPEED')
order by sname,pname;

PROMPT ----WORKLOAD STATS-----

PROMPT CPUSPEED: Stands for I/O transfer speed during a workload statistics colletion
PROMPT MAXTHR: The maximum I/O throughput
PROMPT SREADTIM: The Single Block Read time statistic shows the average time (in ms) for a random single block read.
PROMPT MREADTIM: The Multiblock Read time statistic shows the average time (in ms) for a sequential multiblock read.
PROMPT MBRC: The Multiblock Read Count statistics shows the avg multiblock read count in blocks
select sname,pname,pval1,pval2 from SYS.AUX_STATS$ 
where pname in ('DSTOP','DSTART','STATUS','CPUSPEED','FLAGS','MAXTHR','MBRC','MREADTIM','SLAVETHR','SREADTIM')
order by sname,pname;
