Oracle stress testing-orastress!

Source: Internet
Author: User
Tags dio

Orastress mainly tests the database pressure. It can test the CPU or memory pressure of the database (in read-only mode), or test the I/O capability of the database using two methods: normal INSERT and direct path INSERT.
Orastress can only run in windows, but it can also test the pressure on remote servers.

1. Download
Yes
Http://www.linxcel.co.uk/orabm/orastress.zip

2. Installation
Orastress! The user and data used are similar to orabm, and the installation method is similar to orabm.

1) Expand the tablespace
Orastress! The orabm user is used as the test user, and the orabm user uses the tools tablespace as the default tablespace by default. In this test, the data of 10 Warehouses will be imported, and the database is about 1 GB. Therefore, ensure that the tablespace used by orabm is greater than 1 GB.
SQL> alter database datafile 'e: ORACLEORADATAORACLE9ITOOLS01. dbf' resize 1500 m;
2) delete an orabm user
Skip this step if your database does not have an orabm user
Drop user orabm cascade;
3) create a user
Sqlplus system/pwd @ orabm_user
Remote database usage:
Sqlplus
System/pwd @ tnsname

@ Orabm_user
4) create a table
Sqlplus system/pwd @ orabm_tab
Remote database usage:
Sqlplus
System/pwd @ tnsname

@ Orabm_tab
5) load data
Orabmload Warehouses 10
Load 10 warehouses data here for testing. The data volume is about 1 GB, And the execution time is estimated to be about 15 minutes.
For a remote database
Set LOCAL = tnsname
Then execute orabmload
6) Create an index
Sqlplus system/pwd @ orabm_ind
Remote database usage:
Sqlplus
System/pwd @ tnsname

@ Orabm_ind
7) analysis table and Index
Sqlplus system/pwd @ orabm_analyze
Remote database usage:
Sqlplus
System/pwd @ tnsname

@ Orabm_analyze
8) Authorization
Connect to the target server and run the command in sys.
Grant execute on DBMS_LOCK TO ORABM
9) create a table used to insert a stress test record
Sqlplus orabm/orabm @ orastress_tab. SQL
Remote database usage:
Sqlplus
Orabm/orabm @ tnsname

@ Orastress_tab. SQL
10) Create orastress! Packages and stored procedures used
Create package:
Sqlplus orabm/orabm @ orastress. plh
Create a package:
Sqlplus orabm/orabm @ orastress. plb
Remote database usage:
Sqlplus
Orabm/orabm @ tnsname

@ Orastress. plh
Sqlplus
Orabm/orabm @ tnsname

@ Orastress. plb
11) apply for a registration code
After completing the above steps, you can use orastress to build a test environment in oracle! The test is started. But orastress! It is a shared software. We can use only one concurrent test database without registration. We can apply for a 20-day trial registration code with unlimited functions.
To apply for a registration code, follow these steps:
Run
D: Pressure of programeroracle tools orastress> "orastress !. Exe"
Serial: 1274-0B71
Licensed to: DEFAULT
Evaluation version: 1 session only per database
The obtained 1274-0B71 is the serial number (different machines have different serial numbers)
Then log on
Http://www.linxcel.co.uk/software_orastress_key.html


Enter the relevant information. Make sure that the email address is correct and enter the serial number in the last input box. If the email address is submitted and approved, you can get a registration code.

Run after obtaining the registration code
D: Pressure of programeroracle tools orastress> "orastress !. Exe "register
In the displayed dialog box, enter registration information.

Unfortunately, I have not yet obtained the key at the current location.

3. Use
Orastress! It can run in four modes:
READ: READ-only, test CPU and memory. If you only test a single instance, the effect is the same as that of orabm.
OLTP: test the simulated Online Transaction System
INS: test the I/O pressure of a common insert statement.
DIO: test the I/O pressure of direct path insert.

Orastress! The usage is as follows:
Orastress! -S sess-iterations-list-t transacts-per-sess-c tns-alias-list-m mode [-s batchsize]
Where:
Sess-iterations-list: number of concurrent operations. If you want to test a number of concurrent threads, use good segmentation between multiple threads.
Transacts-per-sess: number of transactions executed concurrently
Tns-alias-list: list of tested instances. To test multiple instances, separate them by commas.
Mode: running mode. See the preceding section.
Batchsize: Optional. It is used in IDS and DIO modes. The default value is 1000. In IDS and DIO mode, when the number of inserted records reaches batchsize, It is submitted once.

We recommend that you use 1, 2, 3, 5, and 10 warehouses to test 50000 concurrent transactions in a single-node database.
We recommend that you use 1, 2, 3, 5, and 10 warehouses for testing 50000 transactions with, and 10 concurrency for multi-node RAC.

The following examples

Example 1:

Orastress! -S 1-T 50000-C inst1.world-M OLTP

Run one iteration-comprising 50000 transactions in 1 session-against inst1.world.
Perform a group of tests and test the inst1.world database by using a session containing 50000 transactions.

Example 2:

Orastress! -S 2-T 50000-C inst1.world, inst2.world-M OLTP

Run a group of tests to issue two concurrent sessions for each database (inst1.world, inst2.world), and each session runs 50000 transactions. The two databases can be:
. Two instances of the same RAC
. Different instances on the same server (non-RAC)
. Different instances on different servers (non-RAC)

Example 3:

Orastress! -S 1, 2, 4-T 50000-C inst1, inst2, inst3, inst4-M read
Run three groups of tests to execute 50000 transactions for each of the four instances with 1, 2, and 4 concurrent sessions:

Orastress! The output result is similar to orabm.

D: Pressure of programeroracle tools orastress> "orastress !. EXE "-S 1-t 100-C oracle9
I-m OLTP
Evaluation version: 1 session only per Database
--- Begin mode = OLTP sess = 1 txn = 100 TNS = Oracle9i Thu Sep 21 17:59:06 2006
Oracle9i #1 W = 9 txn (all) = 100 Xn (SAM) = 79 T (SAM) = 12 TPS = 6.6 d = 2 (2.5%) n = 34 (43%) O = 8
(10.1%) P = 33 (41.8%) S = 2 (2.5%) End = 210906-17:59:22
--- End-Thu Sep 21 17:59:22 2006

D: Pressure of programeroracle tools orastress> "orastress !. EXE "-S 1-T 1000-C Oracle
9i-M OLTP
Evaluation version: 1 session only per Database
--- Begin mode = OLTP sess = 1 txn = 1000 TNS = Oracle9i Fri Sep 22 10:07:49 2006
Oracle9i #1 W = 2 txn (all) = 1000 Xn (SAM) = 799 T (SAM) = 65 TPS = 12.3 d = 40 (5%) n = 304 (38%)
O = 39 (4.9%) P = 385 (48.2%) S = 31 (3.9%) End = 220906-10:09:27
--- End-Fri Sep 22 10:09:27 2006

This test is slow, and you need to be patient during the test.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.