Supporting Hardware - Expert Consolidation in Oracle Database 12c - page 96

Note that the devices have been partitioned in this setup. This was done to align the partition with the storage
array block boundaries, based on a vendor recommendation. Partitioning a LUN also indicates that it is in use and
thus prevents it from being accidentally deleted.

■ if you are using flash-based storage, then it almost always required to align the partition at a 4k
boundary—remember, the page size for nand flash is usually 4k. You could also review the vendor documentation to
update tunables in /sys/block/sd x /queue/ .

Tip

The LUNs need to be saved in a file called orion.lun . You can optionally pass a parameter “testname” to ORION,
in which case the LUNs need to be saved as testname .lun. ORION will make use of large pages by default. If your
system does not have large pages configured, ORION will error unless you specify the -hugenotneeded flag. To perform
a simple, read-only OLTP-like test named “test1,” you need a file test1.lun containing the LUNs to test against. Make
sure that the oracle account has access rights to these LUNs. You invoke ORION using its complete path. After the
calibration run you can check the output of the “summary” file to get an idea about your storage subsystem:

ORION VERSION 12.1.0.1.0

Command line:
-run oltp -testname test1

These options enable these settings:
Test: test1
Small IO size: 8 KB
Large IO size: 1024 KB
IO types: small random IOs, large random IOs
Sequential stream pattern: RAID-0 striping for all streams
Writes: 0%
Cache size: not specified
Duration for each data point: 60 seconds
Small Columns:, 1, 2, 3, 4, 5, 6, 7, 8, 9,
10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20
Large Columns:, 0
Total Data Points: 21

Name: /dev/sdc Size: 1073741824
1 files found.

Maximum Small IOPS=9899 @ Small=17 and Large=0
Small Read Latency: avg=1711 us, min=791 us, max=12316 us, std dev=454 us @ Small=17 and Large=0

Minimum Small Latency=123.58 usecs @ Small=1 and Large=0
Small Read Latency: avg=124 us, min=41 us, max=4496 us, std dev=76 us @ Small=1 and Large=0
Small Read / Write Latency Histogram @ Small=17 and Large=0
Latency: # of IOs (read) # of IOs (write)
0 - 1 us: 0 0
2 - 4 us: 0 0
4 - 8 us: 0 0
8 - 16 us: 0 0
16 - 32 us: 0 0