We have Oracle servers running on dedicated HP 9000 servers with HP-UX 10.20 I have seen suggestions that by disabling the Unix "Last access Update" on Oracle datafiles one can gain remarkable I/O reduction. Apparently, to do this either we make the whole file system "noatime" in /etc/fstab, or apply it to individual datafiles by "Chattr +A file_name".

Could you shed some more light on this? Is there any consequence for disabling "last access time" update for Oracle datafiles?


    Requires Free Membership to View

The amount of overhead that it takes to update the last update file is negligible. I don't think that you will see any performance impact by turning it off. If chatr would make a significant difference, I think Oracle would turn it off when datafiles are created.

This was first published in April 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.