首页 / ORACLE / ORACLE AWR报告生成步骤
ORACLE AWR报告生成步骤
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ORACLE AWR报告生成步骤,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含6796字,纯文字阅读大概需要10分钟。
内容图文
![ORACLE AWR报告生成步骤](/upload/InfoBanner/zyjiaocheng/467/1656935d9a534f238746c915ccb849ca.jpg)
ORACLE AWR报告生成步骤
(以PL/SQL中命令窗口为例)
1.sqlplus或plsql的commod窗口(命令窗口)运行命令
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\awrrpt.sql; -- 具体地址,需要查询得到
--然后在弹出的对话框中输入选择的导出格式html或者txt,一般用html,生成的报告用浏览器查看比较方便。
2.在弹出的对话框中输入数字选择制定选择快照的数量
<img alt="技术分享" src="http://www.mamicode.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAh0AAAEfCAIAAABqIuMmAAAgAElEQVR4nOzdd1hUVxow8AOm7PdlN7tpbjZld5NYQuwV0cSoWBiKFIEZegdl6L1aEexYERVsOChq7IIUEZQiICIivcP0wjAFhmHK+/1xzeyEqNkkZNHP83vex+fOufeee+Yyz3297RwEGIZhGDZ60Fg3AMMwDPv/Cs4rGIZh2GjCeQXDMAwbTTivYBiGYaMJ5xUMwzBsNOG8gmEYho0mnFcwDMOw0YTzCoZhGDaacF7BMAzDRhPOKxiGYdhownkFwzAMG004r2AYhmGjCVEoFDKZXFFRMTQ05ODgQCaTHz58+MxFXVxcYmNjR2WrW7dupVAoFAolPz9frVYThQkJCe7u7gqFQntJpVKZkJAgFAoBQKVSBQYGEis+efIEAPLz88lkMuVHlZWVxFrHjx8nk8mhoaHEx8HBwYKCgpMnT2qqlcvlvb29SUlJP29bXV3dvn37Xtz+e/fuUSgUW1vbiIiI37gLtFy/fp1MJjMYjN+2+pMnT8hkcnl5+e9vyTP19fU5OzuTyWQymRwcHDxi7t69e52cnIaHh/+grWMY9spBe/bsWbp0KZ/PVyqV4eHhq1ev7uvre+aikydPNjMz+/2b3Lx58/bt28vKysrKytzc3EpKSgYGBnbt2nXgwIErV65ERkYKBAJiSbFYHBIS8u677xJNCggIOHnyJLGivb29SCRKTEx0c3Mr+5FAIJDJZOnp6YmJicXFxRYWFkQ9VCr166+/9vPz07Th6NGj33///YwZM0a0rbu7e/bs2UZGRi9of1VVlYuLS1lZ2eXLl9esWfP7dwiDwdDX1y8pKXneAgKBQCQSPW9uf3+/jY3NgQMHfn9Lnkkul9+/f9/CwiIoKOjn/+eor6+fPn06j8f7g7aOYdgrB5WVlfn4+BAfMjMzIyMj/+hNUiiUK1euENP29vZ37ty5deuWh4cHUbJ3796YmBgA4HK58fHxGRkZa9asYbPZALBkyZKWlhZiMSIX7tq1a8+ePdqVl5eXW1pajtiiRCI5evRoQECApkQmk9XX15NIJO3F6urqIiIijh8/7uLi8oL219TUODs7//rv/SLu7u5379593tzExMTTp0+/YPUNGzakpKSMbpNGiI6OPnXq1DNnWVpaEn8gDMMwAECFhYWaY/qJEydCQkIAQCgU+vn5UalUPz+/gwcPAsDJkyeDg4MzMjKIJRkMRnBwcE1NTWpqKpVKvX79OlHe2tpKrBUeHn7mzJlnbjI3Nzc0NFShUJSVlQUFBTEYjPPnz3t5eRFzjx8/Hh4eDgB5eXk2NjYAQCKRmEwmAJw9e3bTpk0AcPXq1djYWJlMlpiYuHv37h07dmiyS0lJiaen561bt/z8/FQqlWajNBrN399fuxkMBsPY2Fi7xNfXl0ajtbW12dnZPW9/HT582MrKatKkSVQqNSIiQiaTAUBmZiaVSqVSqUVFRQAQFxdH7JwjR474+/trkujPKRSK8PBwKpU6ceJE4lQgJycnMDAwODj44sWLACCRSMLCwmbPnv3dd99t2LCB+EZqtZrYRHBwMHGiEBsbe/To0c2bNx8+fFhTeUVFBVHV0aNHiRKJROLv70/8gZKTk4nC5ORkoqrW1tbntRMAwsLCNPVodiCVSl23bt2MGTNecDqFYdjrZmReIW4YeHh4XLx48dq1a0ePHl26dCkAlJaWbtq0iZgGAKFQ6OTkNHny5KNHj9JotICAgFu3bjGZTFdX12vXrp06derjjz9+wYWd7OxsY2NjJyenjo4OAGCxWLGxsZcuXers7JwxY8bWrVuVSqWvr293dzcAmJmZaS7NpaWlWVhYUKnU/v5+AEhJSZk1a9apU6cSEhIOHDigUCjq6uq+/PLLLVu2nDx5MioqamhoiFgxIyNjRF7p6enRziv5+fnh4eFSqfTx48dOTk7Pa3lRUdH69esXLlxIo9EuXLggl8tPnz4dGhpKo9FoNJqfn19ubu7ly5ddXFwmT56ckZERGRnp7u7+zKqGhoaio6NTUlJoNNqCBQsaGhru3r0bHR195MiRPXv2eHl5ZWZmDg0NnT9/3sLCwtXV9erVq8S9qISEhJSUlD179uzevdvDw0OpVG7btm369Ok0Gm3Dhg1paWkKhaKmpiY0NDQ9PX3Pnj3+/v7E2Yy3t3dWVta1a9dOnDixaNEiANi5c2doaOiePXv27NljY2PT1NT0vC8+Iq/Q6fSAgAAajZaRkWFgYEDcAMMwDIPn5RVbW9vS0tKqqqrq6mrNobm1tVX7EhNxpkJMr1+//uDBgwwGw8vLq6qqKj8/f+3atc/bZG9vb0xMTGVlZXp6+r59+4j/6kokkoCAAFdX1/Xr12/ZskWhUEyaNKm0tDQ/P3/evHn5+fkA0NDQEBUV1dDQsGvXLhqNNjg4CAAsFouo1s/P79KlS01NTatWrSJmnTp1SnOf+RfzSlpa2sqVK4uKipKTk5cuXUqktGd6+PChq6ur5mNUVNT+/fuJ6cDAwCNHjgDAkSNHfH19iUIiBf5cSEiI5lECJyenkpKSoaGh+vr60NBQOzu7b775Zvv27cTcLVu2HD9+XLMij8fLycmhUCh2dnafffaZSqXatGnT+vXrAUCpVHp4eFy6dGloaKipqWnTpk12dnbz588nvjuFQikuLq6qqnrw4AFxpkWhUBYvXmxnZ2dnZzdv3jwizT/TiLxiZ2dXVlZGTJuZmXE4nOetiGHY6wbdvn1bk1dOnjwZFBQEAIODg25ubq6uri4uLjdu3CDmPnr0yMrKSrPm7t27ExMTien169cfOXJEJBIlJSUFBQW9+CkpHx8fzd0CBweHmzdvas/VJIOgoCAXFxcXF5dPP/2UuPxlYWFx//59YjESidTd3V1fX9/c3EyUREREHDt27MmTJ5p76Xfu3NEkwjNnzmjfXwEAOp1uYmKi+fjkyRM3NzcXFxdjY+Mvv/wyNzf3ee0vKSlxcHDQfNywYYPmmlJQUBCRAPbs2bN169YX7AQAsLKyKiwsJKadnJwqKys7OztDQkJKS0vVavX27dsTEhKIuTExMdq3T65evbp+/XqVSqVSqUgk0vDwcHx8PI1GI+b6+PhkZGQIBILo6Ojr16+r1WriMh0AyOVyd3d34s96+fJlYrt5eXlqtVrzVN7zhIeHHzt2TPNx0aJFmnv15ubmXC73xatjGPb6QAUFBc7OzsSRJS0tjbi/ojlQcjicb7/9FgDUanVVVZWJiYnmALRt27a4uDhiOioq6uDBgyKRaNu2bUFBQYGBgUQmeCZvb++MjAyiHk1euXDhQklJCYfDoVKpFRUV2ssbGRkR/+VfvXr1/fv3iRWNjIyEQuHGjRtjY2PVanVpaamfn19ra6tQKIyOjr58+bJcLg8KCiouLiYaf+LEibVr12oar1aru7q6li9f/vND6sOHD19wf0WtVt+5c8fa2lqzVnx8/M6dO4l6/Pz80tPTiaxANOwFu764uDgwMFAul+fl5X366addXV3Hjx8n8joAJCUlEacgxO7dt2+fprYlS5a0t7cT08uXL5fL5QkJCXPnzhWLxSUlJYGBgT09Pbm5uba2tsQyNBqNeDRD82cViUQLFiwAAEdHx7y8PKLw0KFDnZ2dz/vWgYGBKSkpmjacPXt248aNarX6wIEDn376Kb6/gmGYBhKLxfv37zcxMTExMfHz86PT6cPDw1OnTiWRSCYmJpaWlo8ePQKAHTt2LF26dPLkySYmJvX19Tweb86cObNmzert7W1vb585c+bChQvz8vICAwPLy8vLy8uPHDkSFhb2zE12d3evW7eO2GJKSgqRM5KSkmbOnGlvb9/Q0KBZ8tatW8bGxpMmTSLu5BN31IkVf/jhB6VSyWazo6OjTUxM3N3du7q6iLX6+vrCwsJIJJLmBo+fn9+CBQumTZtmZmZGPLl07NixFStWTJo0ycTEpKCgQLPFzZs3f//993p6esR/539u48aNixcv1tPTMzExIZrKYDDCwsKIVu3atYvP57u4uMydO3fWrFlkMlkikbxg75eWlhoZGSUkJNja2lpaWgoEgu3btxNVzZkzZ/bs2cTZGJ1O9/X1tbW1Je7bE+dkJiYmxM5JTExMSUkJDw93dXX18PAg3oPp7+8/fPgwUZWBgcH06dNLSkoWL168atUqExMTc3PzqqoqAOjs7HRxcRnxtxhBIBBYWVlNnz59/vz53t7emvKsrCwTE5Pk5GR9fX3Nq0IYhmEIAJRKJZPJZDKZYrEYANRqtVgsJko0182FQiGbzRYKhUwmUy6XK5VKPp/P5/MVCsXw8LBAIODz+XV1da6urtnZ2dnZ2cnJyZr/bv+cSCQi6tc8sjU8PMzj8Ua8BjEwMMBkMoVCoea+PZ/PJ1bULDM4OMhkMkf8f1kmk2kvw+VyeTyeQCBgMplKpZJoAIvFIr4OcTOG0NfXx+Fw+vr6pFLpM1suEAiIBYj9oN1OJpNJvB7I4XCIncNms7WfSXsmJpM5NDSkUqmIhDc8PExURdSged9QIpFo7iQR34hYTCgUCoVCoiU8Ho/4CxJUKhWxDJfLJd7s0bRT+7Fg4rto764RlEoli8USCAQ8Hm/E9S4mk6lWq4eGhvh8/ou/JoZhr49R7selubmZeOJWc88ZwzAMe63g/sEwDMOw0YTzCoZhGDaaUFpaWkZGRnt7+/Dw8KlTp06fPv28VzeuX79OvE8+KoinaX9xscrKypSUlPT09Lq6ut+8rcHBwfPnz9fW1v7mGl5mdDr91KlTv7nbSgzDsNGFbG1tJ06c+OTJE7lcTiKRpk2b9ryXrhFCU6ZM+f2bvHLlirOz8/Tp038xr9y+fdvf3z86OnrlypXaryL+Wj09PQghTVcx/59pa2ubNWsW8T4mhmHYmEPV1dWa1+YvXLjwgp7wa2trX9DPx3/v8ePHR44cWbJkyS8+K7Vly5a9e/cS079z01VVVT09Pb9hRaLjk9+z6f+BLVu2EN24YRiGjbln9zsJAMTjwrdu3aqvrweAR48elZeXay62iMXi27dvDw4O1tTUZGdna94dGRwczM7OzsnJKSkpefz48fO2Ojg4aGJiQjzy+0xKpbKgoIB43z47O1vTPXtJSQnRMOLx1uzs7Hv37qnV6oKCgqKiouf1mFJaWvrgwQNN9/sMBqO4uFilUhUXF2dnZ2ueUWYymUTlhYWFxBPP+fn5NjY2zs7OhYWFmix49+5dYjEAkEgkhYWFcrm8qqoqOztb+2ndzs7O7Ozs6upqTcmtW7eys7M17yGOMDAwUFBQIJFIGhoasrOziV4g7969q9mNRUVF7e3t7e3t9+7dy8nJKSwsvHPnzu3btwEgNjb21KlTd+/e1b7WJxQKiXYSbyBVV1fn5uay2WwGg5Gdnf17ritiGIa9wMi8QrzMeOTIERcXF3d3dysrq5kzZwJAamqqqamppmP53t7ehQsXmpubh4WFubq6hoSENDU1icXibdu2ubu729nZffjhh9rdfozAZrNJJNIL8opMJgsICJg9e/bs2bNdXV2Jp5Zzc3Ndf3T48OGWlhZXV9d//vOfLi4uAQEBX3zxRXp6+jNri4+PX7hwoSZllpeXT5gwwcHBwc/Pz9XVdfPmzXw+v6Ojg+gj0t3dferUqcTLN1QqddasWfPmzQsJCSEGHMvKynJ1dQ0ODg4KCjpx4kRHR8f8+fNtbGxCQkJcXV0jIiIaGxsBoL6+3sfHx9XV1dnZOScnBwDOnDnj5+cXFBREpVLPnDnz83M1Lpe7dOlSEokUGRnp6uoaEBDw6NGj4OBgfX19YgEKhbJmzZqbN2/+4x//IJPJxHup3t7eRUVF27ZtMzMzIzpYIwY36+rqSkxMDAoKCgoKCg4OLi4uPnDggJWV1dy5c+Pi4pycnPT09P6b+1sYhmG/1si8Qoy/YmBgoFmC6AoFANra2jQjZQFAenq6oaEh8SJefHz8oUOH2tvbiR63ZDLZi4fG+sW8QkhOTtZ0PQIAq1atIoaJBIDly5cTY7G4u7sTnZTU19drv6s/wqVLlzSX+wAgICDA0dGRmLa1tX3w4MHZs2c1fWV2dXXV1NQQ0zt37kxNTdWsmJ2d3dHRERAQEBAQ8Omnn6pUqpSUFBMTE6J3zoCAgBMnTvT09Hh5eRE1sNls4gRFT0/P29s7ICDA09Nz8uTJz7wGePny5e+++45493DXrl2bNm1SqVTm5ubE3MbGRqJ/Nmtr6+Hh4SNHjhw6dEilUpHJ5MTERKJXNGLTjx49qqys/Pzzz4l2Ll261NPTEwA6OjqmTJlCnKkQ 本文系统来源:http://www.cnblogs.com/yizitrd/p/5636021.html
内容总结
以上是互联网集市为您收集整理的ORACLE AWR报告生成步骤全部内容,希望文章能够帮你解决ORACLE AWR报告生成步骤所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。