RE: OT - Blog entry on hugepages

The Oracle documents say you can tell hugepages are being used  by the 
following:
      To make sure that the configuration is valid, the HugePages_Free value 
should be smaller than HugePages_Total and there should be some HugePages_Rsvd. 
The sum of Hugepages_Free and HugePages_Rsvd may be smaller than your total 
combined SGA as instances allocate pages dynamically and proactively as needed.
This does seem to indicate they are being used, but I was wondering if there's 
any other way to truly see it. I'm wondering if anyone can confirm my thinking 
on this. I used

>ipcs
 ------ Shared Memory Segments --------
 key        shmid      owner     perms      bytes       nattch     status
 0x00000000 29097988   oracle    640        4096       0
 0x00000000 29130757   oracle    640        4096       0
 0x0e2f3c64 29163526   oracle    640        4096       0
 0x00000000 29655047   oracle    640        268435456  59
 0x00000000 29687816   oracle    640        51271172096 59
 0x2894b058 29720585   oracle    640        2097152    59

I could be wrong, but 51271172096/1024/1024/1000H (since pages are in kbytes, 
this would seem to be my 48G SGA). I'm not sure what the one above it is and it 
is big enough to make me wonder.

Does that look like it makes sense?

(Still wish someone had some test results to show it really helps)

Thanks,

Jed

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Rich Jesse
Sent: Wednesday, April 04, 2012 3:10 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: OT - Blog entry on hugepages

Hey Kyle,

>   Does anyone have metrics to identify memory access problems on AIX
> other than paging and scanning stats that might be solved with largepages?
>   Recently an AIX customer  was seeing slow I/Os from an NFS filer but
> fast local I/O response times.  Of course the customer blamed the NFS
> filer, but the filer reported constant speeds during good periods as
> well as bad. I

Was CPU consistent between the tests?

Does the init.ora filesystemio_options='SETALL'?  I'm not sure how that affects 
the NFS mount, but for JFS2 mounts, that will cause Oracle to automagically use 
CIO (Ora10g and up) and also AIO, if enabled, IIRC.
Oracle does this regardless of the mount options specified in /etc/filesystems, 
again for JFS2.

I'm theorizing that if CIO's not used, there could be Oracle data files in the 
filecache of the local storage, which could result in higher CPU while still 
appearing as PIO to Oracle.  This would also depend on the VMO filecache 
settings of minperm/maxperm/maxclient.  I watch the filecache constantly in 
AIX's excellent nmon in the memory window, as well as a vmstat monitoring 
script containing:

vmstat -v|grep -E 'numperm|file pages'

Hope this drivel helps!  I don't claim to be an expert in this, but have been 
delving into this stuff now to help me determine how big I can make my buffer 
cache w/o causing AIX (v5.3) paging.

GL!

Rich

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Other related posts: