Oracle++12.1.0.2+参数最佳实践.doc
免费下载
Message-ID: <1328698508.147.1532343079718.JavaMail.javamailuser@localhost>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_146_1996965709.1532343075675"
------=_Part_146_1996965709.1532343075675
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
<html>
<head>
<!-- MS Word on Windows doesn't realise the encoding is UTF-8 unles=
s this meta tag is present -->
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Du=
tf-8">
<title>Oracle 12.1.0.2 =E5=8F=82=E6=95=B0=E6=9C=80=E4=BD=B3=E5=AE=
=9E=E8=B7=B5</title>
<style>
body, p, td, table, tr, .bodytext, .stepfield {
=09 font-family: Arial, Helvetica, FreeSans, sans-serif;
}
.panel {
margin: 10px;
padding: 10px;
border: 1px solid #999;
background-color: #f0f0f0;
}
.noteMacro { border-style: solid; border-width: 1px; border-col=
or: #F0C000; background-color: #FFFFCE; text-align:left;}
.warningMacro { border-style: solid; border-width: 1px; border-=
color: #c00; background-color: #fcc; text-align:left;}
.infoMacro { border-style: solid; border-width: 1px; border-col=
or: #69c; background-color: #D8E4F1; text-align:left;}
.tipMacro { border-style: solid; border-width: 1px; border-colo=
r: #090; background-color: #dfd; text-align:left;}
.informationMacroPadding { padding: 5px 0 0 5px; }
table.infoMacro td, table.warningMacro td, table.tipMacro td, t=
able.noteMacro td, table.sectionMacro td {
border: none;
}
.grid {
margin: 2px 0px 5px 0px;
border-collapse: collapse;
}
.grid th {
border: 1px solid #ccc;
padding: 2px 4px 2px 4px;
background: #f0f0f0;
text-align: center;
}
.grid td {
border: 1px solid #ccc;
padding: 3px 4px 3px 4px;
} =20
</style>
</head>
<body style=3D"background-color: white; padding: 10px;">
<h1>Oracle 12.1.0.2 =E5=8F=82=E6=95=B0=E6=9C=80=E4=BD=B3=E5=AE=9E=
=E8=B7=B5</h1>
<p class=3D"LSF0Ctrl0">=E5=A6=82=E4=B8=8B=E6=95=B0=E6=8D=AE=E5=BA=
=93=E5=8F=82=E6=95=B0=E5=8F=82=E8=80=83=E6=B1=9F=E8=8B=8F=E7=A7=BB=E5=8A=A8=
=E6=A0=B8=E5=BF=83=E6=95=B0=E6=8D=AE=E5=BA=93=E5=8F=82=E6=95=B0=E9=85=8D=E7=
=BD=AE=EF=BC=8C=E5=B9=B6=E8=BF=9B=E8=A1=8C=E7=9B=B8=E5=85=B3=E8=AF=B4=E6=98=
=8E=EF=BC=9A</p><p class=3D"LSF0Ctrl0">=EF=BC=88=E5=90=8C=E6=97=B6=E5=8F=AF=
=E5=8F=82=E8=80=83=E8=BF=99=E4=B8=AA=E6=96=87=E6=A1=A3=EF=BC=9A<a href=3D"a=
ttach_edb7507e0dc211d5c3d793a96fdb584f">Oracle 12C数据库&=
#25512;荐参数指导表_20170314_v1.xlsx</a=
>=EF=BC=89</p><div class=3D"table-wrap"><table class=3D"confluenceTable"><t=
body><tr><td class=3D"confluenceTd"><p align=3D"center">=E5=8F=82=E6=95=B0<=
/p></td><td class=3D"confluenceTd"><p align=3D"left">=E5=BB=BA=E8=AE=AE=E5=
=80=BC</p></td><td class=3D"confluenceTd"><p align=3D"center">=E5=A4=87=E6=
=B3=A8</p></td></tr><tr><td class=3D"confluenceTd"><p>resource_manager_plan=
</p></td><td class=3D"confluenceTd"><p align=3D"left">FORCE:</p></td><td cl=
ass=3D"confluenceTd"><p align=3D"left">=E5=85=B3=E9=97=AD=E8=B5=84=E6=BA=90=
=E8=AE=A1=E5=88=92</p></td></tr><tr><td class=3D"confluenceTd"><p>enable_dd=
l_logging</p></td><td class=3D"confluenceTd"><p align=3D"left">TRUE</p></td=
><td class=3D"confluenceTd"><p>=E5=BC=80=E5=90=AFddl=E6=93=8D=E4=BD=9C=E8=
=AE=B0=E5=BD=95=E5=88=B0alert=E6=97=A5=E5=BF=97</p></td></tr><tr><td class=
=3D"confluenceTd"><p>sec_max_failed_login_attempts</p></td><td class=3D"con=
fluenceTd"><p align=3D"left">100</p></td><td class=3D"confluenceTd"><p>=E9=
=80=82=E5=BD=93=E5=A2=9E=E5=A4=A7</p></td></tr><tr><td class=3D"confluenceT=
d"><p>deferred_segment_creation</p></td><td class=3D"confluenceTd"><p align=
=3D"left">FALSE</p></td><td class=3D"confluenceTd"><p>=E5=85=B3=E9=97=AD=E5=
=BB=B6=E8=BF=9F=E6=AE=B5=E5=88=9B=E5=BB=BA</p></td></tr><tr><td class=3D"co=
nfluenceTd"><p>_undo_autotune</p></td><td class=3D"confluenceTd"><p align=
=3D"left">FALSE</p></td><td class=3D"confluenceTd"><p>=E5=85=B3=E9=97=ADUND=
O=E8=87=AA=E5=8A=A8=E8=B0=83=E6=95=B4</p></td></tr><tr><td class=3D"conflue=
nceTd"><p>undo_retention</p></td><td class=3D"confluenceTd"><p align=3D"lef=
t">10800</p></td><td class=3D"confluenceTd">=C2=A0</td></tr><tr><td class=
=3D"confluenceTd"><p>parallel_force_local</p></td><td class=3D"confluenceTd=
"><p align=3D"left">TRUE</p></td><td class=3D"confluenceTd"><p>=E5=85=B3=E9=
=97=AD=E8=B7=A8=E8=8A=82=E7=82=B9=E5=B9=B6=E8=A1=8C</p></td></tr><tr><td cl=
ass=3D"confluenceTd"><p>parallel_max_servers</p></td><td class=3D"confluenc=
eTd"><p align=3D"left">32</p></td><td class=3D"confluenceTd"><p>=E5=9C=A8OL=
TP=E4=B8=8A=E5=BB=BA=E8=AE=AE=E8=AE=BE=E5=BE=97=E8=BE=83=E5=B0=8F=EF=BC=8C=
=E4=BB=A5=E5=85=8D=E5=BD=B1=E5=93=8D=E7=B3=BB=E7=BB=9F</p></td></tr><tr><td=
class=3D"confluenceTd"><p>_px_use_large_pool</p></td><td class=3D"confluen=
ceTd"><p align=3D"left">TRUE</p></td><td class=3D"confluenceTd">=C2=A0</td>=
</tr><tr><td class=3D"confluenceTd"><p>_use_adaptive_log_file_sync</p></td>=
<td class=3D"confluenceTd"><p align=3D"left">FALSE</p></td><td class=3D"con=
fluenceTd">=C2=A0</td></tr><tr><td class=3D"confluenceTd"><p>_optimizer_use=
_feedback</p></td><td class=3D"confluenceTd"><p align=3D"left">FALSE</p></t=
d><td class=3D"confluenceTd">=C2=A0</td></tr><tr><td class=3D"confluenceTd"=
><p>_db_block_numa</p></td><td class=3D"confluenceTd"><p align=3D"left">1</=
p></td><td class=3D"confluenceTd"><p align=3D"left">=E5=85=B3=E9=97=ADnuma<=
/p></td></tr><tr><td class=3D"confluenceTd"><p>_clusterwide_global_transact=
ions</p></td><td class=3D"confluenceTd"><p align=3D"left">False</p></td><td=
class=3D"confluenceTd"><p align=3D"left">=C2=A0</p></td></tr><tr><td class=
=3D"confluenceTd"><p>_cleanup_rollback_entries</p></td><td class=3D"conflue=
nceTd"><p align=3D"left">2000</p></td><td class=3D"confluenceTd"><p align=
=3D"left">=C2=A0</p></td></tr><tr><td class=3D"confluenceTd"><p>_drop_stat_=
segment</p></td><td class=3D"confluenceTd"><p align=3D"left">1</p></td><td =
class=3D"confluenceTd"><p align=3D"left">=C2=A0</p></td></tr><tr><td class=
=3D"confluenceTd"><p>_external_scn_logging_threshold_seconds</p></td><td cl=
of 9
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论