Shulou(Shulou.com)06/01 Report--

Sometimes in order to install EM in the database, it is impossible to generate AWR reports graphically, so you need to generate AWR reports manually. ORACLE provides a sql. You can generate AWR reports manually. First, create a directory to generate reports. Here is / home/oracle/AWR.

$mkdir AWR$ cd AWR$ pwd/home/oracle/AWR

Enter sqlplus

[oracle@ocp] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 30 02:41:04 2015Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options

Execute the script,? Means to execute sql on behalf of $ORACLE_HOME,@. Two report formats, html and txt, are provided by default. The default is html format.

@? / rdbms/admin/awrrpt.sqlCurrent Instance~ DB Id DB Name Inst Num Instance- 1425858850 ORCL 1 orclSpecify 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: html

Select the time period of the report extracted from the system, which is usually set for 7 days. ORACLE will display all the reports within seven days on the screen.

Enter value for num_days: 7Listing the last 7 days of Completed Snapshots

Enter the snap id at the beginning and the snap id at the end to indicate the time period for intercepting the report

Instance DB Name Snap Id Snap Started Level--orcl ORCL 81 29 Dec 2015 13:33 1 82 29 Dec 2015 15: 00 1 83 29 Dec 2015 16:00 1 84 29 Dec 2015 17:00 1 85 29 Dec 2015 18:00 1 86 29 Dec 2015 19:00 1 87 29 Dec 2015 20:00 1 88 29 Dec 2015 21:00 1 89 29 Dec 2015 22:00 1 90 29 Dec 2015 23:00 1 91 30 Dec 2015 00:00 1 92 30 Dec 2015 01:00 1 93 30 Dec 2015 02:00 1Specify the Begin and End Snapshot Ids~~Enter value for begin_snap: 83Begin Snapshot Id specified: 83Enter value for end_snap: 93End Snapshot Id specified: 93

Specify the report name, if not, enter directly, and the system will generate the report name according to the on-screen prompt name.

Report written to awrrpt_1_83_93.html

Just download it locally and check it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.