发新话题
打印

[转载]Swingbench

[转载]Swingbench

信息来源:邪恶八进制信息安全团队(www.eviloctal.com

Swingbench is a free load generator (and benchmarks) designed to stress test an Oracle database (9i or 10g). It can be downloaded here. See my blog for new releases and what Im currently working on.

About SwingBench

SwingBench consists of a load generator, a coordinator and a cluster overview. The software enables a load to be generated and the transactions/response times to be charted.

Whilst It is primarily used to demonstrate Real Application Clusters it can also be used to demo functionality such as online table rebuilds, standby databases, online backup and recovery etc.

The code that ships with SwingBench includes two benchmarks, OrderEntry and CallingCircle. OrderEntry is based on the "oe" schema that ships with Oracle9i/Oracle10g. It has been modified so that Spatial, Intermedia and the Oracle9i schema's do not need to be installed. It can be run continuously (that is until you run out of space). It introduces heavy contention on a small number of tables and is designed to stress interconnects and memory. It is installed using the "oewizard" located in the bin directory.

CallingCircle simulates the SQL that is generated for a online telco application. It requires data files to be generated and copied from the database server to the load generator before each run, it typically requires between 1 and 8 Gig of disk space. Both benchmarks are heavily CPU intensive. Experience has shown that you require at least 1 processor of load generator to every 2 processors of database server. It is designed to stress the CPU and memory without the need for a powerful I/O subsystem. Its is installed using the "ccwizard" located in the bin directory

The entire framework is developed in Java and as a result can be run on wide variety of platforms. It also provides a simple API to allow developers to build their own benchmarks.

http://www.dominicgiles.com/
曾几何时,有人对我说:装B遭雷劈。我说:去你妈的。于是,这个人又对我说:如果再说脏话,上帝会惩罚你的。我说:我操上帝。结论:彪悍的人生不需要上帝。

TOP

发新话题