与oracle有关的HP-UX内核参数.doc
上传人:qw****27 上传时间:2024-09-12 格式:DOC 页数:11 大小:97KB 金币:15 举报 版权申诉
预览加载中,请您耐心等待几秒...

与oracle有关的HP-UX内核参数.doc

与oracle有关的HP-UX内核参数.doc

预览

免费试读已结束,剩余 1 页请下载文档后查看

15 金币

下载此文档

如果您无法下载资料,请参考说明:

1、部分资料下载需要金币,请确保您的账户上有足够的金币

2、已购买过的文档,再次下载不重复扣费

3、资料包下载后请先用软件解压,在使用对应软件打开

HP-UXKernelConfigurationforOracleDBsLastUpdate:July2002(Oracle8/8i/9iR1/9iR2,HP-UX11/11i)Oracle9irecommendations:MinimumRAM=256MBHP-UX11orHP-UX11iSwapSpace:Minimum2xRAMor400MB,whicheverisgreateravailableDiskSpace:3GBCreateOSUNIXgroupsforOraclesystem:OSDBAgroup:RequiredOSOPERgroup:OptionalORAINVENTORYgroup:OptionalAPACHEgroup:RecommendedPleasecheckappendix6forSCHED_NOAGEusageandMLOCKwww.changshady.comNote:TheseareminimumkernelrequirementsforOracle9i.Ifyouhavepreviouslytunedyourkernelparameterstolevelsequaltoorhigherthanthesevalues(becarefulforfilesystemcacheparameters–dbc_max_pct,dbc_min_pct),continuetousethehighervalues.Asystemrestartisnecessaryforkernelchangestotakeeffect.KernelParameterSettingPurposeHP-UX11.xKernelParameterDescription,Default/RecommendedValuebufpagesNumberofstaticBufferPagesof4kB,enablesdynamicbuffercache(seedbc_max/min_pct).default=0recommended:0www.tangxiaobei.comdbc_max_pctMaxdynamicBufferCachesizeinpercentofsystemmemory,whenbufpagesandnbufarebothsetto0,default=50.recommended:between3and10It'smoreefficienttousesystemmemoryforOracleSGAinsteadoffilesystembuffercachedbc_min_pctMindynamicBufferCachesizeinpercentofsystemmemory(seedbc_max_pct),default=5.recommended:between2and5www.changshady.comfs_asyncseeappendix2andappendix6KSI_ALLOC_MAX(NPROC*8)Definesthesystemwidelimitofqueuedsignalthatcanbeallocated.max_async_portsMaximumnumberofasyncdskportsthatcanbeopenatonetime.Ifanerrorhappenswiththis,itwillnotshownintheOraclealert.logfileorintracefiles.default:50recommended:max.noofshadowprocesses+noofparallelquerieslavesmax_thread_procMaxno.ofthreadsallowedineachprocessdefault:64recommended:<=Oracle8.1.6=64>=Oracle8.1.7=256maxfilesSoftFileLimitperProcess,softlimitfornumberoffilesaprocessisallowedtohaveopensimultaneously.Processescanincreasetheirsoftlimituntiltheyreachthehardlimitmaxfiles_lim.default=60.recommended=1024maxfiles_limHardFileLimitperProcess,default=1024.recommended=1024(default).