Oracle Stuff I Should Have Known !

Oracle, the obvious, and the not so Obvious …

Oracle on ext4 warning

with 7 comments

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 8.1.7.4 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.

Andy

About these ads

Written by Andy Campbell

19 May, 2010 at 09:18

Posted in Linux, Oracle

7 Responses

Subscribe to comments with RSS.

  1. I guess I’m not seeing the warning. You say ext4 and ext3 both did the install in 6 minutes. Presumably you meant on the new laptop and aren’t saying what the old laptop had for FS (ext2? ReiserFS? something else?)
    So it appears your issue was NOT ext4 but rather the new laptop and/or the difference between 32 bit and 64 bit. Can you explain why you think your issue was ext4? I’m apparently missing it in what you wrote.

    MensaWater

    25 February, 2011 at 20:56

  2. Your website has been wonderful ; Never short of digital Media , Fun download, Fun reading -Find out more about digital media Download – Torrents

    download

    28 February, 2012 at 09:22

  3. Hi everyone, it’s my first go to see at this web site, and article is actually fruitful designed for me, keep up posting these articles or reviews.

    seagate freeagent media player price

    1 December, 2012 at 10:10

  4. Growth of New Mobile Geosocial |

    geosocial

    13 February, 2013 at 09:40

  5. Smartphone user shared map feature with retailers boosting Geolocation services |

    Conchita Busler

    13 February, 2013 at 10:33

  6. Your way of describing all in this article is truly fastidious, every one can
    without difficulty know it, Thanks a lot.

    russia

    23 April, 2013 at 04:21

  7. What’s up to every body, it’s my first pay a visit
    of this blog; this webpage consists of amazing and actually good data in support of readers.

    Robin

    24 April, 2013 at 02:50


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: