<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> <br> </p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> <span style="white-space:pre"><span style="color:rgb(44,44,44); font-family:SimSun; font-size:20px; line-height:20px; text-align:center"><strong>ORACLE10G RAC+AIX53</strong></span></span></p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> <br> </p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> AWR报告提取(ORACLE10G RAC+AIX53)<br style="padding:0px; margin:0px"> 1、如果不在oracle用户下请切换到oracle用户<br style="padding:0px; margin:0px"> su - oracle</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> 2、以sysdba权限登录数据库<br style="padding:0px; margin:0px"> sqlplus "/as sysdba"</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> 3、执行awrprt命令<br style="padding:0px; margin:0px"> SQL> @?/rdbms/admin/awrrpt</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> 4、出现选择awr的输出格式界面（默认选HTML比较直观）<br style="padding:0px; margin:0px"> -----------------------------------------------<br style="padding:0px; margin:0px"> Current Instance<br style="padding:0px; margin:0px"> ~~~~~~~~~~~~~~~~</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> DB Id DB Name Inst Num Instance<br style="padding:0px; margin:0px"> ----------- ------------ -------- ------------<br style="padding:0px; margin:0px"> <span style="border-bottom-width:1px; border-bottom-style:dashed; border-bottom-color:rgb(204,204,204); z-index:1">2566595041</span> samp 2 samp2</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> <br style="padding:0px; margin:0px"> Specify the Report Type<br style="padding:0px; margin:0px"> ~~~~~~~~~~~~~~~~~~~~~~~<br style="padding:0px; margin:0px"> Would you like an HTML report, or a plain text report?<br style="padding:0px; margin:0px"> Enter 'html' for an HTML report, or 'text' for plain text<br style="padding:0px; margin:0px"> Defaults to 'html'<br style="padding:0px; margin:0px"> Enter value for report_type: html</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> Type Specified: html</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> -----------------------------------------------<br style="padding:0px; margin:0px"> 5、选择采集日期间隔(下述samp1\samp2是RAC节点的两个实例)<br style="padding:0px; margin:0px"> -----------------------------------------------<br style="padding:0px; margin:0px"> Instances in this Workload Repository schema<br style="padding:0px; margin:0px"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p>
<p style="line-height:23.8px; color:rgb(44,44,44); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden"> DB Id Inst Num DB Name Instance Host<br style="padding:0px; margin:0px"> ------------ -------- ------------ ------------ ------------<br style="padding:0px; margin:0px"> * <span style="border-bottom-width:1px; border-bottom-style:dashed; border-bottom-color:rgb(204,204,204); z-index:1">2566595041</span> 2 samp samp2 p650b<br style="padding:0px; margin:0px"> <span style="border-bottom-width:1px; border-bottom-style:dashed; border-bottom-color:rgb(204,204,204); z-index:1">2566595041</span> 1 samp |
|
转播
