Understand Oralce storage I/O tools-orion

I. orion Overview
1. Description
Orion is a tool provided by Oracle to test io performance. It can be used to simulate Oracle Database IO, or to simulate the Strip function of ASM.

2. Advantages and Disadvantages of orion
2.1 Advantages
No need to run load runner and configure a large number of clinet

No need to run the oracle database and prepare a large amount of test data

The test results are more representative. For example, in random I/O testing, the software can make the storage hit rate close to 0, and simulate the real IOPS of the disk, however, it is difficult for the load runner to achieve this, and the final disk IOPS needs to be converted.

You can customize a certain proportion of write operations as needed (no write operations by default), but note that if there is data on the disk, be careful when the data is overwritten.

2.2 disadvantages
Up to now, the custom overall running time and pressurization range cannot be specified. Here it is completely automatic

You cannot perform custom operation types, such as table scan and load testing. However, you can combine them with the oracle database to achieve this effect.

3. Load types supported by orion
Small random IO: OLTP (online transaction processing) applications are mainly random read/write, the size is the same as the size of the data block (generally 8 K ).
Such an application mainly focuses on IOPS and the average latency of a request. Orion can simulate a random IO load. The specified read/write percentage, the specified IO size, and the specified IOs and IOs are distributed on different disks.

Large Continuous IO: Data Warehouse applications, data loading, backup, and recovery generate continuous read/write streams. These reads and writes are composed of multiple 1 m io. These applications process large amounts of data, mainly focusing on the overall data throughput of MBPS

Large random IO: a continuous read/write and other database activity simultaneously access the disk. Based on striping, a continuous read/write is extended to multiple disks. Therefore, at this level of the disk, many consecutive reads and writes are regarded as random 1 m io, also known as multi-user continuous IO.

Hybrid load: Orion can simulate the first two types of load simultaneously: small random IO, large continuous IO. This will allow you to simulate 8 K random read/write load of OLTP and 4 consecutive backup loads of 1 m io read/write.

For different IO loads, Orion can be tested at different IO pressures and obtain performance parameters: MBPS, IOPS, and IO delay time. Load is a term that represents the number of asynchronous IOs. Internally, at each load level, Orion software has been sending I/O requests as soon as possible to complete the I/O load at this level. For Random Loads (large and small), the load level is the number of I/OS. For large continuous loads, the load level is the number of consecutive read/write streams and the IO of each read/write stream. Testing a specified load within the load level will help you understand how performance is affected.

4. orion supports character devices for testing
Theoretically, ORION can be used to test any character device that supports Asynchronization. ORION has been tested on the following types of devices.
Storage of DAS (directed_attatched)

SAN (storage-area network) storage

NAS (network-attachedstorage) storage is not supported, probably because no dba will load the database on nas

Recommended reading:

Tips for using temporary tables in Oracle stored procedures

Dynamic SQL of stored procedures in Oracle packages

Refresh the materialized view of Oracle stored procedures

Simple stored procedures for connecting and calling Oracle databases

Oracle Stored Procedure traversal query records

1 2 3 Next Page