.comment-link {margin-left:.6em;}

Oracle Sponge -- Now Moved To Wordpress

Please use http://oraclesponge.wordpress.com

Tuesday, December 13, 2005

System Statistics

In 9i onwards we can use DBSMS_STATS.GATHER_SYSTEM_STATS to get some becnchmarks for system performance that are then usable by the cost-based optimizer, and it seems to me that these statistics ought to be a pretty good way of comparing different hardware (cutting through all the CPU GHz, disk speed, controller caching comparisons that are so detailed that it's virtually impossible to get useful information from them).

There don't seem to be many reference values for system statistics available anywhere, so over at the Dizwell Forum I started a thread to collect them -- if you have a moment then I'd appreciate it if you could post a very brief description of your hardware and the results of:
select pname,pval1 from sys.aux_stats$
where sname = 'SYSSTATS_MAIN'
/

Hopefully something analytical will come out of it.

If you don't want to register at Dizwell then feel free to reply below: thanks.

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home