Artikelen gelabeld: Oracle

Oracle Data Placement on XtremIO

Many customers these days are implementing Oracle on XtremIO so they benefit from excellent, predictable performance and other benefits such as inline compression and deduplication, snapshots, ease of use etc. Those benefits come at a price and if you just consider XtremIO on a usable gigabyte basis, it does not come [...]

Oracle ASM vs ZFS on VNX

In my last post on ZFS I shared results of a lab test where ZFS was configured on Solaris x86 and using XtremIO storage. A strange combination maybe but this is what a specific customer asked for. Another customer requested a similar test with ZFS versus ASM but on Solaris/SPARC and [...]

SLOB full table scans

A short post in follow-up to the previous one on ZFS vs ASM: I wrote that I had to create a procedure to get full table scans on SLOB data. SLOB is designed to do random I/O (and lots of it 😉 but my test required FTS as well. Here is the [...]

Oracle ASM vs ZFS on XtremIO

Background In my previous post on ZFS I showed how ZFS causes fragmentation for Oracle database files. At the end I promised (sort of) to also come back on topic around how this affects database performance. In the meantime I have been busy with many other things, but ZFS issues still [...]