Large pagesize and datafile sticky bit

This is a question about Oracle on Solaris.

Jim Mauro's Solaris Internals, p.203, says that memory with large pagesize 4M instead of the regular 8k size boosts Oracle performance by 12% (assuming sun4u CPU class I think). Anyone has a system with a page size larger than 8k on Ultrasparc? You can check by the command pagesize. Is Oracle indeed running faster on such systems?

Adrian Cockroft et al.'s Sun Performance and Tuning 2nd ed, p.165, says that turning on sticky bit (chmod +t) for datafiles improves performance, because inode update becomes asynchronous. Has anyone done this?

Any insight is appreciated.

Yong Huang
yong321_at_yahoo.com Received on Thu Nov 22 2001 - 18:01:14 CST