Re: Large pagesize and datafile sticky bit

Thanks for your answer and Casper Dik's. How do I know my system is actually using a non-base page size such as 4mb? I ran netstat -k on our database server (Solaris 2.6). Under bp_map_backend header, page_size is 16384, and there're multiple alloc_[size]'s and inuse_[size]'s, from 16k up to 2M. I believe these [size]'s are size of slab objects. Can I say our system has at most 2M page size? Also, under kmem_default_backend, page_size is 8192.

BTW, our Oracle version has _use_ism default to true.

Yong Huang
yong321_at_yahoo.com

ultrasparc3_at_hotmail.com wrote in message news:<20011022.221434.1781_at_us3.pacbell.net>...
> In <b3cb12d6.0111221601.4f60a856_at_posting.google.com> yong321_at_yahoo.com (Yong Huang) writes:
> all UltraSPARCs support page sizes larger than 8k but OS support
> is limited. "Intimate Shared Memory", ISM, used by databases
> can use 4MB pages if they are available. The database documentation
> should include information on how to configure ISM. even when you use
> ISM the output of pagesize will remain 8k.
Received on Fri Nov 23 2001 - 17:38:08 CST