Re: Large pagesize and datafile sticky bit

[[ PLEASE DON'T SEND ME EMAIL COPIES OF POSTINGS ]] yong321_at_yahoo.com (Yong Huang) writes:

>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?

That's not how it works; the UltraSPARC hardware supports multiple pagesizes; when using shared memory segments the system will sue 4MB pages.

pagesize will still return 8192.

Casper

--
Expressed in this posting are my opinions.  They are in no way related
to opinions held by my employer, Sun Microsystems.
Statements on Sun products included here are not gospel and may
be fiction rather than truth.