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 first published in April 2002

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close