USING Auotomatic Shared Memory Management - 数据库编程

ata Mining and Real Application Testing options SQL> exec dbms_workload_repository.create_snapshot; PL/SQL procedure successfully completed. SQL> @/opt/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/awrrpt.sql Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ----------- ------------ -------- ------------ 2735005832 RHYS 1 RHYS 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 ------------ -------- ------------ ------------ ------------ * 2735005832 1 RHYS RHYS oracle-one Using 2735005832 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 value for num_days: 1 Listing the last day's Completed Snapshots Snap Instance DB Name Snap Id Snap Started Level ------------ ------------ --------- ------------------ ----- RHYS RHYS 9 06 Aug 2013 00:07 1 10 06 Aug 2013 00:08 1 11 06 Aug 2013 00:10 1 Specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter value for begin_snap: 9 Begin Snapshot Id specified: 9 Enter value for end_snap: 11 Specify the Report Name ~~~~~~~~~~~~~~~~~~~~~~~ The default report file name is awrrpt_1_9_11.html. To use this name, press

to continue, otherwise enter an alternative. Enter value for report_name: Using the report name awrrpt_1_9_11.html

USING Auotomatic Shared Memory Management(三)