Q

Disabling

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.

This was last published in April 2002

Dig Deeper on Oracle DBA jobs, training and certification

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close