SQL> @?/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
249066282 ORA11GR2 1 ORA11GR2
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type:
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 249066282 1 ORA11GR2 ORA11GR2 zh
Using 249066282 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
ORA11GR2 ORA11GR2 5 15 Jan 2017 11:18 1
6 15 Jan 2017 12:00 1
7 15 Jan 2017 13:00 1
8 15 Jan 2017 14:00 1
9 15 Jan 2017 15:51 1
10 15 Jan 2017 17:00 1
11 15 Jan 2017 18:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 10
Begin Snapshot Id specified: 10
Enter value for end_snap: 11
End Snapshot Id specified: 11
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_10_11.html. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: hr
Using the report name hr
<li class="awr">'(NULL)' indicates a missing parameter value </li>
<li class="awr"> A blank in the End Snapshot indicates the same value as the BeginSnapshot</li>
</ul>
<table border="0" class="tdiff" summary="This table displays name and value of multi-valued init.ora parameters"><tr><th class="awrbg" scope="col">Parameter Name</th><th class="awrbg" scope="col">Begin value</th><th class="awrbg" scope="col">End value (if different)</th></tr>
<tr><td scope="row" class='awrc'>control_files</td><td class='awrc'>/u01/app/oracle/oradata/ORA11GR2/control01.ctl</td><td class='awrc'>  </td></tr>
<tr><td scope="row" class='awrnc'><div class="hidden">control_files
</td><td class='awrnc'>/u01/app/oracle/oradata/ORA11GR2/control02.ctl</td><td class='awrnc'>  </td></tr>Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
249066282 ORA11GR2 1 ORA11GR2
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type:
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 249066282 1 ORA11GR2 ORA11GR2 zh
Using 249066282 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
ORA11GR2 ORA11GR2 5 15 Jan 2017 11:18 1
6 15 Jan 2017 12:00 1
7 15 Jan 2017 13:00 1
8 15 Jan 2017 14:00 1
9 15 Jan 2017 15:51 1
10 15 Jan 2017 17:00 1
11 15 Jan 2017 18:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 10
Begin Snapshot Id specified: 10
Enter value for end_snap: 11
End Snapshot Id specified: 11
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_10_11.html. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: hr
Using the report name hr
<li class="awr">'(NULL)' indicates a missing parameter value </li>
<li class="awr"> A blank in the End Snapshot indicates the same value as the BeginSnapshot</li>
</ul>
<table border="0" class="tdiff" summary="This table displays name and value of multi-valued init.ora parameters"><tr><th class="awrbg" scope="col">Parameter Name</th><th class="awrbg" scope="col">Begin value</th><th class="awrbg" scope="col">End value (if different)</th></tr>
<tr><td scope="row" class='awrc'>control_files</td><td class='awrc'>/u01/app/oracle/oradata/ORA11GR2/control01.ctl</td><td class='awrc'>  </td></tr>
<tr><td scope="row" class='awrnc'><div class="hidden">control_files
</table><p />
<hr align="left" width="20%" /><p />
<a class="awr" href="#36">Back to init.ora Parameters</a>
<a class="awr" href="#top">Back to Top</a><p />
<p />
<p />
<p />
<p />
<p />
<p />
<p />
<a class="awr" name="8790"></a>
<h3 class="awr">Dynamic Remastering Stats</h3>
<p />
No data exists for this section of the report.
<p />
<a class="awr" href="#top">Back to Top</a><p />
<p />
End of Report
</body></html>
Report written to hr
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@zh ~]$ ls
hr.lst
[oracle@zh ~]$
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31399171/viewspace-2132463/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
更改重做日志的名称或位置
下一篇：
expdp
请登录后发表评论
登录
全部评论
