Shulou(Shulou.com)06/01 Report--

SwingBench introduction:

SwingBench consists of a load generator, a coordinator, and a cluster overview. The software makes it possible to generate load and map the transaction / response time of the chart.

SwingBench can be used to demonstrate and test technologies such as practical application cluster, online table reconstruction, standby database, online backup and recovery, etc.

The code that comes with SwingBench includes six benchmarks, OrderEntry,SalesHistory,TPC-DS Like,JSON,CallingCircle and StressTest..

OrderEntry is based on the "oe" mode that comes with Oracle11g / Oracle12c. It has been modified so that the Spatial,Intermedia schema does not need to be installed. It can run continuously (until you run out of space). It introduces a lot of contention on a few tables to emphasize interconnection and memory. It is installed using "oewizard" located in the bin directory. Both pure jdbc and pl / sql (lower network overhead) variants exist in benchmarking.

SalesHistory is based on the "sh" architecture included with Oracle11g / Oracle12c and is designed to test the performance of complex queries when running against large tables. It is read-only and can be scaled to the default size from 1GB to 1TB. Custom schemas also allow you to create smaller and larger schemas

CallingCircle (not recommended) simulates the SQL generated for online telecom applications. It requires data files to be generated and copied from the database server to the load generator before each run, usually 1 to 8 GB of disk space. Both benchmarks are CPU-intensive. Experience has shown that you need at least one processor load generator to every two processors on the database server. It is designed to emphasize CPU and memory without the need for a powerful I / O subsystem. It is installed using "ccwizard" located in the bin directory

StressTest simply triggers random inserts, updates, selections, and updates based on a well-known table.

JSON Stresstest is based on a simple JSON document that models people flying between airports. It follows the basic CRUD model.

TPC-DS likes that Benchmark is a benchmark similar to TPC-DS. It has query and transaction workloads in separate configuration files.

SwingBench download:

SwingBench official website: http://www.dominicgiles.com/swingbench.html, you can install the latest 2.6version of SwingBench under download. You need to install jdk8 first. You can download rpm and install it directly from the official website of oracle. After decompressing the SwingBench package file, it is as follows:

Generate test data:

Take order entry as an example:

The graphical interface generates test data and pressure test:

Cd / tmp/swingbench/bin

. / oewizard

Select version2.0, next

Select create the order entry schema,next

Configure connect string, username and password, next

Configure datafile, next of tablespaces

Configure size, next of schema

The default is the number of CPU * 2, next

Click yes, next

Start running the sql script to produce test data, and you need to wait here.

The data has been generated successfully, and the stress test can be done next.

Start the performance stress test:

Cd / tmp/swingbench/bin

. / swingbench

Modify connect string, configure server monitoring-related configuration parameters, and adjust load ratio and number of users of transtions.

You can collect database information and generate awr reports. Start the pressure test

You can view the stress test results on the output tab.

You can also save the results in the bin directory in XML format

Compare the test results to generate a html file, using bmcompare tool

The command line interface generates test data and pressure tests:

[root@oracle bin] # time. / oewizard-cl-create-scale 1-cs / / oracle:1521/xcky-dba system-dbap oracle-u soe1-p soe1-ts soe-df / u01/app/oracle/oradata/xcky/soe.dbf-tc 4-sThe following statement failed: GRANT EXECUTE ON dbms_lock TO soe1: Due to: ORA-01031: insufficient privilegesThe following statement failed: begin $IF DBMS_ DB_VERSION.VER_LE_10_2 $THEN-- Use the default stats collection approach dbms_stats.gather_schema_stats (OWNNAME= > 'SOE1' ESTIMATE_PERCENT= > DBMS_STATS.AUTO_SAMPLE_SIZE, BLOCK_SAMPLE= > TRUE, METHOD_OPT= > 'FOR ALL COLUMNS SIZE SKEWONLY', DEGREE= > 4, GRANULARITY= >' ALL', CASCADE= > TRUE) $ELSIF DBMS_DB_VERSION.VER_LE_11_2 $THEN-- Oracle 11g release 2. Emable concurrent stats collection dbms_output.put_line ('database version is less than or equal to 11.2'); DBMS_STATS.SET_GLOBAL_PREFS ('CONCURRENT','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','WAREHOUSES','INCREMENTAL','TRUE') DBMS_STATS.SET_TABLE_PREFS ('SOE1','INVENTORIES','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','PRODUCT_INFORMATION','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS ('SOE1','PRODUCT_DESCRIPTIONS','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','ORDERENTRY_METADATA','INCREMENTAL','TRUE') DBMS_STATS.SET_TABLE_PREFS ('SOE1','CUSTOMERS','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','ADDRESSES','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS ('SOE1','ORDER_ITEMS','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','ORDERS','INCREMENTAL','TRUE') DBMS_STATS.SET_TABLE_PREFS ('SOE1','LOGON','INCREMENTAL','TRUE'); DBMS_STATS.GATHER_SCHEMA_STATS (' SOE1'); $ELSIF DBMS_DB_VERSION.VER_LE_12 $THEN-- Oracle 12c. Concurrent Stats collection work slightly different in this release execute immediate q' [ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'DEFAULT_PLAN']'; execute immediate q' [ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 4]'; DBMS_STATS.SET_GLOBAL_PREFS ('CONCURRENT','MANUAL'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','WAREHOUSES','INCREMENTAL','TRUE') DBMS_STATS.SET_TABLE_PREFS ('SOE1','INVENTORIES','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','PRODUCT_INFORMATION','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS ('SOE1','PRODUCT_DESCRIPTIONS','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','ORDERENTRY_METADATA','INCREMENTAL','TRUE') DBMS_STATS.SET_TABLE_PREFS ('SOE1','CUSTOMERS','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','ADDRESSES','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS ('SOE1','ORDER_ITEMS','INCREMENTAL','TRUE'); DBMS_STATS.SET_TABLE_PREFS (' SOE1','ORDERS','INCREMENTAL','TRUE') DBMS_STATS.SET_TABLE_PREFS ('SOE1','LOGON','INCREMENTAL','TRUE'); DBMS_STATS.GATHER_SCHEMA_STATS (' SOE1'); $END end : Due to: ORA-20001: Invalid input values for pnameORA-06512: at "SYS.DBMS_STATS", line 26595ORA-06512: at "SYS.DBMS_STATS" Line 26751ORA-06512: at line 17 per sec = | Datagenerator Run Stats | = Connection Time 0:00:00.004Data Generation Time 0:03:18.996DDL Creation Time 0:03:47.528Total Run Time 0:07:06.530Rows Inserted per sec 60836Data Generated (MB) per sec 5.0Actual Rows Generated 13002033Post Creation Validation Report==The creation of the schema appears to have been unsuccessful. See the following sections for further details.Valid Objects=Valid Tables: 'ORDERS','ORDER_ITEMS','CUSTOMERS','WAREHOUSES','ORDERENTRY_METADATA','INVENTORIES','PRODUCT_INFORMATION','PRODUCT_DESCRIPTIONS','ADDRESSES','CARD_DETAILS'Valid Indexes:' PRD_DESC_PK','PROD_NAME_IX','PRODUCT_INFORMATION_PK','PROD_SUPPLIER_IX','PROD_CATEGORY_IX','INVENTORY_PK','INV_PRODUCT_IX','INV_WAREHOUSE_IX' 'ORDER_PK','ORD_SALES_REP_IX','ORD_CUSTOMER_IX','ORD_ORDER_DATE_IX','ORD_WAREHOUSE_IX','ORDER_ITEMS_PK','ITEM_ORDER_IX','ITEM_PRODUCT_IX','WAREHOUSES_PK','WHS_LOCATION_IX','CUSTOMERS_PK','CUST_EMAIL_IX','CUST_ACCOUNT_MANAGER_IX','CUST_FUNC_LOWER_NAME_IX','ADDRESS_PK','ADDRESS_CUST_IX' 'CARD_DETAILS_PK','CARDDETAILS_CUST_IX'Valid Views:' PRODUCTS','PRODUCT_PRICES'Valid Sequences: 'CUSTOMER_SEQ','ORDERS_SEQ','ADDRESS_SEQ','LOGON_SEQ' 'CARD_DETAILS_SEQ'Valid Code: Invalid Objects (1) = Invalid Tables: Invalid Indexes: Invalid Views: Invalid Sequences: Invalid Code:' ORDERENTRY'Missing Objects (0) = Missing Tables: Missing Indexes: Missing Views: Missing Sequences: Missing Code: Schema Createdreal 7m51.663suser 3m23.913ssys 0m24.096s [root@oracle bin] #. / charbench-u soe1-p soe1-uc 1-min 10-max 200-rt 00:01-a-s-r scale1_100user.xml

In addition to swingbench stress testing tools, the SwingBench official website also provides other gadgets for monitoring oracle databases, such as cpumonitor, dbtimemonitor, monitorDB, datagenerator, etc.

MonitorDB tool:

Cd / tmp/MonitorDB/bin

Modify the configuration file monitordb.xml, save Username, Password and ConnectString after configuration, and start the program.

. / monitordb

Such as the dbtimemonitor tool:

Cd / tmp/dbtimemonitor/bin

Modify the configuration file databases.xml, save Username, Password and ConnectString after configuration, and start the program.

. / dbtimemonitor

Such as the cpumonitor tool:

Cd / tmp/cpumonitor/bin

Modify the configuration file cpu.xml, save HostName, Username and Password after modification, and start the program

. / cpumonitor

Reference:

Http://blog.csdn.net/xiaofan23z/article/details/7978998

Http://www.dominicgiles.com/swingbench.html

Attachment: http://down.51cto.com/data/2366902

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.