awr报表生成方法

13594135

可以通过调用oracle数据库服务器里awrrpt.sql或awrrpti.sql生成awr报表。存储位置在$ORACLE_HOME/rdbms/admin之中。awrrpti.sql脚本与awrrpt.sql类不同就是在awrrpti.sql脚本中，可以指定数据库ID和实例ID。

以sys身份登录sqlplus.运行@/home/oracle//app/oracle/product/10.2.0/db_1/rdbms/admin/awrrpti.sql命令。SQL*Plus: Release 10.2.0.4.0 - Production on Sun Mar 6 00:30:12 2011Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> @/home/oracle//app/oracle/product/10.2.0/db_1/rdbms/admin/awrrpti.sqlSpecify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Would you like an HTML report, or a plain text report?Enter 'html' for an HTML report, or 'text' for plain textDefaults to 'html'Enter value for report_type: 根据实际情况进行操作