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

1. Connect to oracle database on the local command line

Sqlplus / nolog

SQL > conn system/oracle@98149

2. Execute the command to generate AWR report

SQL > @? / rdbms/admin/awrrpt.sql

Current Instance

~

DB Id DB Name Inst Num Instance

--

1244647887 ORAL 1 oral

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 html here

Enter the value of report_type: html

Type Specified: html

Instances in this Workload Repository schema

~

DB Id Inst Num DB Name Instance Host

--

* 1244647887 1 ORAL oral s11ora11

Using 1244647887 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 without

Specifying a number lists all completed snapshots.

-enter the number of days to view the report here

Enter a value for num_days: 1

Listing the last day's Completed Snapshots

Snap

Instance DB Name Snap Id Snap Started Level

--

Oral ORAL 17512 23 March 2018 00:00 1

17513 23 March 2018 00:30 1

17514 23 March 2018 01:00 1

17515 23 March 2018 01:30 1

17516 23 March 2018 02:00 1

17517 23 March 2018 02:30 1

17518 23 March 2018 03:00 1

17519 23 March 2018 03:30 1

17520 23 March 2018 04:00 1

17521 23 March 2018 04:30 1

17522 23 March 2018 05:00 1

17523 23 March 2018 05:30 1

17524 23 March 2018 06:00 1

17525 23 March 2018 06:30 1

17526 23 March 2018 07:00 1

17527 23 March 2018 07:30 1

17528 23 March 2018 08:00 1

17529 23 March 2018 08:30 1

17530 23 March 2018 09:00 1

-enter the snap_id of the corresponding time

Specify the Begin and End Snapshot Ids

~ ~

Enter the value of begin_snap: 17529

Begin Snapshot Id specified: 17529

Enter the value of end_snap: 17530

End Snapshot Id specified: 17530

Specify the Report Name

~ ~ ~

The default report file name is awrrpt_1_17529_17530.html. To use this name

Press to continue, otherwise enter an alternative.

-enter directly and generate a report under the command line startup directory path

Enter a value for report_name:

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.