-----------------------------------------------------------
--        name  cbostats
--     version  0.0
-- description  This script reports the system statistics 
--              from sys.aux_stat$.
--    synopsis  No arguments.
--       usage  
--    comments  The query is from Oracle Corp.
--              The nine statistics reported are collected
--              for the CBO. The RDBMS collects so-called
--              'no-workload' statistics by issuing reads 
--              and timing them. The DBA collects 'workload'
--              statistics by using Dbms_Stats.Gather_
--              System_Stats. The statistics are:
--              cpuspeednw    No-workload CPU speed in 
--                            megahertz
--              ioseektim     No-workload average I/O seek
--                            time in milliseconds
--              iotfrspeed    No-workload average I/O 
--                            transfer time in milliseconds
--              cpuspeed      Workload CPU speed in megahertz
--              sreadtim      Workload single-block read time
--                            in milliseconds
--              mreadtim      Workload multi-block read time
--                            in milliseconds 
--              mbrc          Workload multi-block read count
--              maxthr        Workload maximum system I/O 
--                            throughput for parallel queries
--              slavethr      Workload maximum slave process
--                            I/O throughput for parallel
--                            queries
--   copyright  
--    creation  25 October 2007
--      author  David Clement 
--     changes
----------------------------------------------------------
set long 10000
set pages 1000
set lines 256
set serveroutput on size 1000000
/
SELECT sname, pname, pval1
  FROM SYS.aux_stats$
 WHERE sname = 'SYSSTATS_MAIN'
/