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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s