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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: