Regarding chattr and changing atime updates on Oracle database files... here's the response I got from Oracle support: ----------------------------------------------------------------- UPDATE: ======== According to "man chattr": When a file with the 'A' attribute set is modified, its atime record is not modified. This avoid a certain amount of disk I/O for laptop systems.
I am not aware of a reason why this would have negative side-effects, but we cannot endorse it's use. Changing the file attributes like that has not been tested by development, so we will not be able to support it. ----------------------------------------------------------------- And here's my response: ----------------------------------------------------------------- Email Update button has been pressed -- Sending email. 12-MAR-02 13:22:51 : CHANGES MADE VIA MetaLink NOT YET FORWARDED TO OUR INTERNAL SYSTEMS : New info : Well I respectfully request that you guys get on the ball and test this quickly since there are published TPC benchmarks showing that it significanly improves performance!!! ----------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
