EBS trace analysis

Download Trace Analyzer and open traceanalyzer. BAT in Bin.

The trace file of EBS can be analyzed in a graphical interface, without tkprof

You need to configure javahome to confirm that the Java version is 1.6 or later.

Java-version

Effect

 

 

 

 

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

1 swingbench
1.1 Overview
This isOracleAn employee of UK developed on the basis of a abandoned project. The current stable version is 2.2, the latest version is 2.3, based on jdk1.5. This tool is free of charge and can be freely downloaded from the author's website and has detailed user guides. In addition to swingbench, the author also developed two related tools:TestData Generation Tool datagenerator and Trace Analyzer.
Swingbench can perform four different benchmark tests. It has three front-end display Methods: swingbench, charbench, and minibench. charbench is in character mode, and the other two are in Gui mode. In addition, you can use clusteroverview to aggregate all the results. Swingbench is mainly used to displayRACBut it can also be used in a single instance environment. The latest version 2.3 starts to support TimesTen memory.Database.
: Http://www.dominicgiles.com/downloads.html
Author blog: http://www.dominicgiles.com/blog/blog.html
Document address: http://www.dominicgiles.com/Swingbench.pdf

Currently, open-source Oracle stress testing tools on the network are mainly orabm and swingbench. Because orabm does not support Oracle 11g, this test uses swingben for stress testing. In addition, swingbench can also test RAC. Swingbench is UK based Oracle Database Solutions Group developed an Oracle stress testing tool, it seems to be an official waste of a project, the official page on the http://dominicgiles.com/swingbench.html can download the latest software version. Swingbench can run on Windows and Linux platforms. This example uses Windows as an example.

2. Environment Configuration

JDK must be installed on the test client, and Oracle client is not required.

The swingbench version is 2.4. Because it is a test in windows, use the batch files in the winbin directory.

 

The following three BAT files are mainly used:

 

3. Test

3.1 create Test Data

Swingbench does not use customer data, but creates test data according to its own rules. (The generated test data can only be used once. If you need to perform another test after the test, you need to recreate the test data, this is not good)

Run the ccwizard. bat batch file in the target directory.

The following page is displayed:

Click Next to see the following interface:

Select the first create the calling... to create the test data.

Enter the/IP/sid of the database you want to test and the password of the Sys user -- next

The first three items do not need to be modified. You only need to modify the storage path of datafile for the schema automatically created by swingbench. Next

Select a minimum data volume of 100 m and a maximum of 1 TB for Data creation. It usually takes 40-60 minutes to select 10 GB (related to your hardware I/O performance). Next -- finish OK

PS: During the test, it is necessary to determine that there is no impact on the production database. Because the test database disk and the official region use the same storage, swingbench occupies a large amount of IO when doing the production test data, so that my official pipeline has a short Io wait. Lessons learned from the red fruits.

End of data production

 

3.2 recording script

Run the ccwizard. bat batch file, and select generate data for benchmark run.

Start recording test script

Recording ended

 

3.3 Benchmark Test

Run swingbench. BAT in winbin but add parameters to use the recorded script,

Swingbench. Bat-C configfile

The main parameters on the main interface are configured with the corresponding connect string. Create Appendix A for other parameters.

When you enable SSH for the database OS, you can collect the CPU disk Io information of the host.

You can also pull out AWR reports.

Set the insert, update, and select ratios.

Test process

Save test results

 

3.5 statistical comparison of test results

The result is an XML document.

 

 

 

You can use bmcompare. BAT to compare the two test results. The syntax and results are produced locally.

 

 

 

Appendix:

Test parameters of a and swingbench

1. users on swingbench Gui: the number of users (threads) that attach to a database and the amount and tye of work they perform. users can dynamically monitor the response times and loadwhich is displayed in a series of graphs.
Here, users controls the number of users connected to Oracle at the same time. We know that every user connected to Oracle will be assigned a PGA, so here it should be understood as a degree of parallelism.
2. min/Max think time: Minimum/large time for thinking between each transaction. If Min think time is set, the specified time interval is used between each transaction.
3. Max trans: If set, the maximum number of transactions is limited.
4. The top transaction panel: load: indicates the "weight" of the transaction in comparison to othe transactions. A higher weight indicates that it more likely to be run.
This Panel can be used to cancel some fixed transaction types. The load column is mainly used to adjust the weights of some transactions in the test. For example, browse product is mainly a SELECT statement, which can increase its weight to indicate more people to query.
Several parameters in oewizard:
Number of customers: Number of users pre-loaded to the database table.
Number of orders: number of orders pre-loaded to the database table.
The whole OE test is based on nine tables. Is the test result different when oewizard is used to pre-load different data volumes?
For Oracle itself, there is no difference in the performance of indexed tables when the size is certain, but when the number of rows in a table reaches a certain level, such as hundreds of millions of rows, the index performance is not as good as the full table scan performance. Therefore, for the scope allowed by Oe, I think the table data size has no significant impact on performance.
Swingbench is a stress testing tool. The result tpmc also indicates the number of transactions per minute. If more data is pre-loaded and all types of weights in tx are fixed, adjust the number of parallel users to obtain an optimal TPMS value. According to my previous test results, the parallel user is fixed, and the more data is pre-loaded, the smaller the result of the tpmc is, I am also confused. After careful analysis, I found that, the number of parallel users should be modified accordingly.
By modifying the weight of each transaction type in the Tx panel, you can also obtain some Oracle performance parameters, such as increasing the query, if the value of tpmc is similar, this shows that the query capability of this database is good.

B. Introduction to tpmc

According to the definition of TPC, the traffic indicator describes how many new-order transactions can be processed per minute while the system executes the four types of transactions: payment, order-status, delivery, and stock-level. The response time for all transactions must meet the requirements of the TPC-C test specification.
The larger the traffic indicator value, the better!
Tpmc calculation basis
To facilitate the calculation of the shape of the database server, we agree:
"The number of simultaneous online users of the system is 1500 (U1 );
"On average, each user sends two business requests per minute (N1 );
"The system generates 1/3 of the Business requests for updates, queries, and statistics;
"Three transactions (T1) are generated each time the service is updated on average );
"An average of 8 transactions (T2) are generated for each query );
"An average of 13 transactions (T3) are generated for each statistical service );
"The amount of processing during busy hours in a day is 5 times of the average;
"The empirical coefficient is 1.6 (actual engineering experience)
"Considering that the server retains 30% redundancy;
The server requires the following processing capabilities:
TPC-C = U1 * N1 * (t1 + T2 + T3)/3*3 * empirical coefficient/redundancy Coefficient
The processing performance of the application server is estimated to be:
TPC-C = 1500*2*(3 + 8 + 13)/3*5*1.6/0.7 = 274,285 tpmc
The database server is related to the stable operation of the entire system. Considering the high reliability and availability, and pay attention to the scalability and cost-effectiveness of the equipment, the system will configure two high-performance database servers with a TPC-C value not less than 0.28 million.

 

 

Reprint please indicate to: http://blog.csdn.net/xiaofan23z

EBS trace analysis