oracle 9i for hpux configuration guide

《oracle 9i for hpux configuration guide》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Oracle9iforHPUXConfigurationGuideOracle9iforHPUXConfigurationGuide11．修改内核参数21.1.要修改的内核参数21.2.通过SAM修改51.3.手工修改52．建立oracle用户62.1建立oracle目录62.2建立oracle帐户63．配置异步I/O64．确认补丁系统版本65.针对一些oracle指定文件的属性修改61．修改内核参数1.1.要修改的内核参数根据Oracle公司提供的releasenotes，我们了解到，目前共有如下内核参数需要调整：KernelParameterSe

2、ttingPurposeKSI_ALLOC_MAX(NPROC*8)32768Definesthesystemwidelimitofqueuedsignalthatcanbeallocated.MAXDSIZ1073741824bytesReferstothemaximumdatasegmentsizefor32-bitsystems.Settingthisvaluetoolowmaycausetheprocessestorunoutofmemory.MAXDSIZ_642147483648bytesReferstothemaximumdataseg

3、mentsizefor64-bitsystems.Settingthisvaluetoolowmaycausetheprocessestorunoutofmemory.MAXSSIZ134217728bytesDefinesthemaximumstacksegmentsizeinbytesfor32-bitsystems.MAXSSIZ_64BIT1073741824Definesthemaximumstacksegmentsizeinbytesfor64-bitsystems.MAXSWAPCHUNKS(availablememory)/22000

4、MDefinesthemaximumnumberofswapchunkswhereSWCHUNKistheswapchunksize(1KBblocks).SWCHUNKis2048bydefault.MAXUPRC(NPROC+2)4098Definesmaximumnumberofuserprocesses.MSGMAP(NPROC+2)4098Definesthemaximumnumberofmessagemapentries.MSGMNINPROC4096Definesthenumberofmessagequeueidentifiers.MS

5、GSEG(NPROC*4)16384Definesthenumberofsegmentsavailableformessages.MSGTQLNPROC4096Definesthenumberofmessageheaders.NCALLOUT(NPROC+16)4112Definesthemaximumnumberofpendingtimeouts.NCSIZE((8*NPROC+2048)+VX_NCSIZE)34816+VX_NCSIZEDefinestheDirectoryNameLookupCache(DNLC)spaceneededfori

6、nodes.VX_NCSIZEisbydefault1024.NFILE(15*NPROC+2048)63488Definesthemaximumnumberofopenfiles.NFLOCKSNPROC4096Definesthemaximumnumberoffileslocksavailableonthesystem.NINODE(8*NPROC+2048)34816Definesthemaximumnumberofopeninodes.NKTHREAD(((NPROC*7)/4)+16)7184Definesthemaximumnumbero

7、fkernelthreadssupportedbythesystem.NPROC4096Definesthemaximumnumberofprocesses.SEMMAP((NPROC*2)+2)8194Definesthemaximumnumberofsemaphoremapentries.SEMMNI(NPROC*2)8192Definesthemaximumnumberofsemaphoresetsintheentiresystem.SEMMNS(NPROC*2)*2Setsthenumberofsemaphoresinthesystem.Th

8、edefaultvalueofSEMMNSis128,whichis,inmostcases,toolowf