FILESYSTEMIO_OPTIONS=SETALL
Posted: Tue Feb 11, 2025 4:27 am
With I/O Calibrate (VM with 2 cores, 8GB memory) you also get significantly lower values than with the native ARM software:
Instance Parameter: FILESYSTEMIO_OPTIONS=NONE
max_iops = 81092
latency = 0
max_mbps = 3524
max_iops = 24177
latency = .562
max_mbps = 2697
See also my block on FILESYSTEMIO_OPTIONS .
This is still sufficient for a test environment. The performance feels better than an "optimized" iraq telegram data VM on the QNAP NFS storage . But the best thing is the ability to now run an Oracle 23ai database with an Apple Silicon computer without being dependent on other resources.
In the VM configuration, change the device type from IDE to VIRTIO and install the necessary drivers – here is the example for Oracle Linux 8:
dnf -y install qemu-guest-agent.x86_64 libvirt-daemon-driver-qemu.x86_64
systemctl enable --now qemu-guest-agent
I/O performance improves to
Instance Parameter: FILESYSTEMIO_OPTIONS=SETALL
max_iops = 31274
latency = 1.396
max_mbps = 7834
However, this doubles the I/O latency from about 0.6ms to 1.4ms.
Addendum from Mon, September 16, 2024: As part of CloudWorld, Oracle has also made the Oracle 23ai Free Edition available for ARM CPUs under Oracle Linux 8. However, the method described here can also be used to make other Oracle database versions for Linux x86 available on an Apple MAC
Instance Parameter: FILESYSTEMIO_OPTIONS=NONE
max_iops = 81092
latency = 0
max_mbps = 3524
max_iops = 24177
latency = .562
max_mbps = 2697
See also my block on FILESYSTEMIO_OPTIONS .
This is still sufficient for a test environment. The performance feels better than an "optimized" iraq telegram data VM on the QNAP NFS storage . But the best thing is the ability to now run an Oracle 23ai database with an Apple Silicon computer without being dependent on other resources.
In the VM configuration, change the device type from IDE to VIRTIO and install the necessary drivers – here is the example for Oracle Linux 8:
dnf -y install qemu-guest-agent.x86_64 libvirt-daemon-driver-qemu.x86_64
systemctl enable --now qemu-guest-agent
I/O performance improves to
Instance Parameter: FILESYSTEMIO_OPTIONS=SETALL
max_iops = 31274
latency = 1.396
max_mbps = 7834
However, this doubles the I/O latency from about 0.6ms to 1.4ms.
Addendum from Mon, September 16, 2024: As part of CloudWorld, Oracle has also made the Oracle 23ai Free Edition available for ARM CPUs under Oracle Linux 8. However, the method described here can also be used to make other Oracle database versions for Linux x86 available on an Apple MAC