与oracle有关的HPUX内核参数Word文件下载.docx
- 文档编号:21112905
- 上传时间:2023-01-27
- 格式:DOCX
- 页数:15
- 大小:21.92KB
与oracle有关的HPUX内核参数Word文件下载.docx
《与oracle有关的HPUX内核参数Word文件下载.docx》由会员分享,可在线阅读,更多相关《与oracle有关的HPUX内核参数Word文件下载.docx(15页珍藏版)》请在冰豆网上搜索。
NumberofstaticBufferPagesof4kB,
enablesdynamicbuffercache(seedbc_max/min_pct).
default=0
recommended:
0
dbc_max_pct
MaxdynamicBufferCachesizeinpercent
ofsystemmemory,whenbufpagesand
nbufarebothsetto0,
default=50.
between3and10
It'
smoreefficienttousesystemmemory
forOracleSGAinsteadoffilesystem
buffercache
dbc_min_pct
MindynamicBufferCachesizeinpercent
ofsystemmemory(seedbc_max_pct),
default=5.
between2and5
fs_async
seeappendix2andappendix6
KSI_ALLOC_MAX
(NPROC*8)
Definesthesystemwidelimitofqueuedsignalthatcanbeallocated.
max_async_ports
Maximumnumberofasyncdskportsthatcanbeopenatonetime.Ifanerrorhappenswiththis,itwillnotshownintheOraclealert.logfileorintracefiles.
default:
50
max.noofshadowprocesses+noofparallelquerieslaves
max_thread_proc
Maxno.ofthreadsallowedineachprocess
64
<
=Oracle8.1.6=64
>
=Oracle8.1.7=256
maxfiles
SoftFileLimitperProcess,softlimitfornumberoffilesaprocessisallowedtohaveopensimultaneously.Processescanincreasetheirsoftlimituntiltheyreachthehardlimitmaxfiles_lim.
default=60.
recommended=1024
maxfiles_lim
HardFileLimitperProcess,
default=1024.
recommended=1024(default).
maxdsiz
Referstothemaximumdatasegmentsizefor32-bitsystems.Settingthisvaluetoolowmaycausetheprocessestorunoutofmemory.
MaxDataSegmentSize(Bytes)
67108864
=Oracle8.1.7=128MB
=Oracle9i=1073741824bytes
maxdsiz_64bit
Referstothemaximumdatasegmentsizefor64-bitsystems.Settingthisvaluetoolowmaycausetheprocessestorunoutofmemory.
1073741824
=Oracle8.1.7=1073741824bytes
=Oracle9i=2147483648bytes
MAXSSIZ
Definesthemaximumstacksegmentsizeinbytesfor32-bitsystems.
Recommended:
=Oracle9i=134217728bytes
MAXSSIZ_64BIT
Definesthemaximumstacksegmentsizeinbytesfor64-bitsystems.
maxtsize
MaxTextSegmentsize(Bytes)
128MB
max_fcp_reqs
MaximumNumberofConcurrentFiberChannelRequestsPerAdapter
512
maxswapchunks
maximumnumberofswapchunkswhereSWCHUNKistheswapchunksize(1KBblocks).
Default:
2048
=Oracle8i=4096
=Oracle9i=16384
maxusers
ValueofMAXUSERSmacro,limitsthe
Ssstemresourceallocation(nottheactual
numberofusers).Influencesnproc,ninode,nfile.
default=32.
settonumberofconcurrentOracleDBusers+64
maxuprc
MaxNumberofsimultaneoususerprocesses(peruser-id!
).
default=75
Becausealldatabaseprocessesoftenrun
withtheOracleuser-id,it'
s
=Oracle8.1.7=maxusers*5
=Oracle9i=((NPROC*9)/10)
Maxvgs
Max.numberofvolumegroups:
10
increasetothenumberofvolumegroupsyouwouldliketohaveonthesystem(maximum256)
MSGMAP
Definesthemaximumnumberofmessagemapentries.
=Oracle9i=(MSGTQL+2)
MSGMNI
Definesthenumberofmessagequeue
identifiers.
=Oracle9i=(NPROC)
MSGSEG
Definesthenumberofsegmentsavailableformessages.
=Oracle9i=(NPROC*4)(atleast32767)
MSGTQL
Definesthenumberofmessageheaders.
NCALLOUT
Definesthemaximumnumberofpendingtimeouts.
=Oracle9i=(NPROC+16)
NCSIZE
DefinestheDirectoryNameLookupCache(DNLC)spaceneededforinodes.
=Oracle9i=((8*NPROC+2048)+VX_NCSIZE)
VX_NCSIZEisbydefault1024.
nfile
MaxNumberofsimultaneouslyOpen
filessystem-wideatanygiventime.Total
numberofslotsitthefiledescriptortable,
default=16*(nproc+16+maxusers)/10+32+2*(npty+nstrpty)
=Oracle8.1.7=tousedefault.
=Oracle9i=(15*NPROC+2048)
nflocks
MaxNumberofFileLocksavailable
system-wide,(checkwithglanceifyouaregettingclosetothevalueyouhaveset)
default=200or200+10*(num_clients)
=Oracle8.1.7=atleast200+sumoffalldb_filesforallinstancesofOracle
=Oracle9i=(nproc)(atleast4096)
NINODE
Definesthemaximumnumberofopeninodes.
=Oracle9i=(8*NPROC+2048)
NKTHREAD
Definesthemaximumnumberofkernelthreadssupportedbythesystem.
=Oracle9i=(((NPROC*7)/4)+16)
nproc
MaxNumberofProcessesthatcanexist
simultaneouslyinthesystem,
default=(20+8*MAXUSERS),
influencesninode,nfile.
=Oracle8.1.7=tousedefault
=Oracle9i=4096
npty
Numberofptys(pseudottys),
ifyouareusingrlogin/telnet
connectionsfromclientstoserverthen
increasenptyuptothenumberofclient
users,otherwiseusedefault.
ptysarenotusedwhenusingOracleSQL*Net
num_tachyon_adapters
HP-UX11.0only
NumberofTachyon-basedFiberChannelAdaptersintheSystem
minimum5,settorealnumberofFiberChannelAdapters
HP-UX11i–nosupportfortachyonadapters,thenewistachlite,whichdonotusethiskernelparameter.
o_sync_is_o_dsync
Enable/DisabletranslationofO_SYNCto
O_DSYNCinopen()/fcntl()calls,
default=0.
Oracle7.3=o_sync_is_o_dsync=1or
useOraclePatchforBug#310042.
=Oracle7.3=usedefaultforo_sync_is_o_dsync=0(patch#310042notneeded).
SEMMAP
Definesthemaximumnumberof
semaphoremapentries.
=Oracle9i=(SEMMNI+2)
semmni
NumberofSemaphoreIdentifiers,
specifiesthemaximumnumberofsetsof
semaphoresthatcanexistsimultaneously
onthesystem,
default=64.
=Oracle8i=usedefaultoratleast10
perOracledatabase
=Oracle9i=4096
semmns
MaxNumberofSemaphores,definesthe
system-widemaximumnumberof
individualsemaphoresthatcanbe
allocatedforusers,
default=128.
=Oracle8.1.7=256oratleast1per
Oracleprocess
=Oracle9i=(semmni*2)
SEMMNU
Definesthenumberofsemaphoreundo
structures.
=Oracle9i=(NPROC–4)
SEMVMX
Maximumvalueofasemaphore.
=Oracle9i=32768
shmmax(seeappendix4)
maximumallowablesizeofonesharedmemory
segment.TheSHMMAXsettingshouldbelarge
enoughtoholdtheentireSGAinonesharedmemorysegment.Alowsettingcancausecreationofmultiplesharedmemorysegmentswhichmayleadtoperformancedegradation,butnormallyitisoktouseasmallnumberofsharedmemorysegments.
default=0x04000000(64MB)Oracle7
0x40000000(1GB=1073741824Bytes)
Oracle8,8i
db_block_size*db_block_buffers
+shared_pool_size
+log_buffer
+sharedmemoryfortheapplication
or
holdtheentireSGAinonesharedmemorysegment!
(for64bituseuptosizeofphysicalmemory,
butOraclecanalsousemultiplesegments(pleasecheckappendix4))
Shmmni
maximumnumberofsharedmemorysegmentsintheentiresystem.
default=200.
recommended:
=Oracle8.1.7=usedefault.
=Oracle9i=512
Shmseg
maximumnumberofsharedmemorysegmentsoneprocesscanattach.
default=12.
=Oracle8.1.7=10perOracledatabase
=Oracle9i=32perOracledatabase
Streampipes
Setthisparameterto0duringontheinstallationofOracleDBwillreducetheinstallationtime.
Recommendedforinstallation:
swapmem_on
(seeappendix5)
AllowMemorytoExceedSwapSpace
0(off)
1(on)
Swchunk
SwapChunkSize(1KBlocks)
4096
VPS_CEILING
maximumSystem-SelectedPageSizeinkilobytes.
=Oracle9i=64
HelpfulTools:
Tolistallkernelparametersonthesystem
-useSAMor
-/usr/sbim/kmtune–l|more
Toupdateakernelparameter
-UseSAMor
-/usr/sbin/kmtune–s<
kernelparameter>
{=|+}
Tofindout32or64bitHP-UX11.x
getconfKERNEL_BITS
Limitationsonprocesses
-ulimit–a
Thecommandsysdefanalyzesthecurrentlyrunningsystemandreportsonitstunableconfigurationparameters.
-sysdef|more
Tofindout32or64bitOraclesoftwareversion
$cd$ORACLE_HOME/bin
$fileoracle
#ifthisistheanswer,youhave32-bitOracle
oracle:
PA-RISC1.1sharedexecutabledynamicallylinked-notstripped
#ifthisistheanswer,youhave64bitOracle
ELF-64executableobjectfile-PA-RISC2.0(LP64)
APPENDIX1:
db_block_size
Thedefaultdb_block_sizeonHP-UXis2048.Butwerecommendtousethefollowingvalues:
-db_block_size=4096to8192forOLTPApplications,
-db_block_size=8192to16384forDSS/DWApplications.
APPENDIX2:
RawDevices+AsynchronousIO
Werecom
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle 有关 HPUX 内核 参数