Oracle on ext4 warning
I bought a new laptop recently ( Dell Studio XPS 16 ) Core 7i, 8Gb, 7200RPM disk. I installed my Linux distro of choice, Fedora 12, and started installing Oracle. Yeah I know Fedora isn’t a supported OS, but I’ve got almost ever version from 220.127.116.11 to 11.2 and I’ve never really hit any problems for testing use.
To justify my new purchase, I thought I check how lighting fast it was in comparison to my 3+ year old Dell D620. I timed how long it would take to create a 10.2.0.4 database – problem was ….
Old Laptop : ~10 mins
New Laptop : ~20 mins
The only difference I could see was that the old machine was 32bit the new one was 64bit and wasted a bit of time going down that dead end. Anyway after lots of investigation I eventually noticed that the old machine the database filesystem was built with ext3 ( it was created back when Fedora 6 was current), the new laptop was using ext4.
I found a blog Mount options to improve ext4 file system performance and tried the options suggested – and magically the database creation time dropped from 20mins to ~6mins ! Then to confirm I rebuilt the filesystem as ext3, and retained the 6min build time.
ext4 has been standard on the bleeding edge distros for a while now, and is starting to appear in the enterprise Linux distos, Red Hat EL6 beta lists as a feature. So watch your Oracle performance if you are considering ext4.