oracle@DB-Marmer[pam]:/home/oracle$
sq
SQL*Plus: Release
11.2.0.1.0 Production on Sat Jul 21 15:10:24 2018
Copyright (c) 1982,
2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the
Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec
dbms_workload_repository.create_snapshot;
PL/SQL procedure
successfully completed.
SQL>
@?/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name
Inst Num Instance
-----------
------------ -------- ------------
2794571823 PAM 1
pam
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: html
Type Specified:
html
Instances in this
Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst
Num DB Name Instance Host
------------
-------- ------------ ------------ ------------
* 2794571823 1
PAM pam DB-Marmer
Using 2794571823 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: 2
Listing the last 2
days of Completed Snapshots
Snap
Instance DB
Name Snap Id Snap Started Level
------------
------------ --------- ------------------ -----
pam PAM
16966 20 Jul 2018 00:00 1
16967 20
Jul 2018 01:00 1
16968 20
Jul 2018 02:00 1
16969 20
Jul 2018 03:00 1
16970 20
Jul 2018 04:00 1
16971 20
Jul 2018 05:00 1
16972
20 Jul 2018 06:00 1
16973 20
Jul 2018 07:00 1
16974 20
Jul 2018 08:00 1
16978 21
Jul 2018 10:11 1
16979 21
Jul 2018 11:00 1
16980 21
Jul 2018 12:00 1
16981 21
Jul 2018 13:00 1
16982 21
Jul 2018 13:46 1
16983 21
Jul 2018 14:32 1
16984 21
Jul 2018 14:39 1
16985 21
Jul 2018 14:48 1
16986 21
Jul 2018 15:10 1
Specify the Begin
and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for
begin_snap: 16972
Begin Snapshot Id
specified: 16972
Enter value for
end_snap: 16974
Comments
Post a Comment