oracle怎么做awr报告

      发布在:程序维护      评论:3 条评论

oracle怎么做awr报告

因为工作需要,对oracle进行性能分析。第一次学习,记录一下

1. cmd窗口里面登录到oracle

sqlplus  / as sysdba;

2. 运行awrrpt.sql ,oracle自带的

@?\RDBMS\ADMIN\awrrpt.sql 

3. 输入你要生成的报告文件类型

html

4.输入报告的天数范围

比如三天:3

5.根据天数范围会给出节点编号

输入你想要生成报告的起始和结束节点

6. 输入生成的报告文件名和位置

D:\awrreport.html

7. 报告导出结束。

Responses
    加载中...
  1. Howdy! I know this is somewhat off topic
    but I was wondering if you knew where I could get a captcha plugin for my
    comment form? I'm using the same blog platform as yours and I'm having trouble finding one?
    Thanks a lot!

    回复
  2. You should be a part of a contest for one of the greatest blogs on the web. I will recommend this blog!

    回复
  3. I have to thank you for the efforts you've put in penning this blog.

    I'm hoping to check out the same high-grade content by you in the future as well.
    In truth, your creative writing abilities has encouraged me to get my
    very own website now 😉

    回复

滇ICP备14007443号-4