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?
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.
Dig deeper on Oracle DBA jobs, training and certification
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.