Sunday, May 17, 2009  Understanding the different modes of
System Statistics aka. CPU Costing and the effects of multiple
blocksizes - part 3  Back to part 2 Forward to part 4  System
statistics in 9i  In 10g the CPU costing mode is enabled by
default and is supported by the default NOWORKLOAD system
statistics.  But you can use system statistics already in 9i,
although you have to enable them explicitly.  Oracle 9i is out
of support, but I guess there are still a lot of systems out
there that are using the 9.2 release, therefore I find it worth
to mention what you can do in 9i with system statistics. This
can be helpful if you consider to test your application already
in the 9i environment with system statistics before upgrading to
10g.  In most descriptions about 9i and system statistics only
WORKLOAD system statistics are mentioned, but 9i also supports
NOWORKLOAD system statistics, although not in the same full
flavour as 10g does.  You can activate CPU costing in 9i by
running DBMS_STATS.GATHER_SYSTEM_ST