AWR資料的匯出與匯入
有時候在生產系統上分析AWR不太方便，這就需要把生產系統的AWR資訊收集下來，然後匯入到其他的測試機器，進行進一步的分析。
一，匯出AWR資訊
SQL> @?/rdbms/admin/awrextr.sql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer: This SQL/Plus script should only be called under
the guidance of Oracle Support.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~
AWR EXTRACT
~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will extract the AWR data for a range of snapshots ~
~ into a dump file. The script will prompt users for the ~
~ following information: ~
~ (1) database id ~
~ (2) snapshot range to extract ~
~ (3) name of directory object ~
~ (4) name of dump file ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Databases in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id DB Name Host
------------ ------------ ------------
* 1798964329 RAC10G rac1
* 1798964329 RAC10G rac2
The default database id is the local one: '1798964329'. To use this
database id, press to continue, otherwise enter an alternative.
Enter value for dbid: 1798964329
Using 1798964329 for Database ID
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
DB Name Snap Id Snap Started
------------ --------- ------------------
RAC10G .. ... .....
57 18 Sep 2014 10:55
58 18 Sep 2014 12:00
59 18 Sep 2014 13:04
60 18 Sep 2014 14:00
61 18 Sep 2014 15:00
62 18 Sep 2014 16:00
63 18 Sep 2014 17:00
64 18 Sep 2014 18:00
65 18 Sep 2014 19:00
.. ... ....
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 57
Begin Snapshot Id specified: 57
Enter value for end_snap: 65
End Snapshot Id specified: 65
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
ADMIN_DIR /ade/aime_ship_10gR2_050630.0022/oracle/md/admin
AWR_DUMP_DIR /u01/awr
DATA_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/sales_history/
DATA_PUMP_DIR /u01/app/oracle/product/10.2.0/db_1/rdbms/log/
LOG_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/log/
MEDIA_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/product_media/
SUBDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/o rder_entry//2002/Sep
WORK_DIR /ade/aime_ship_10gR2_050630.0022/oracle/work
XMLDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/order_entry/
Choose a Directory Name from the above list (case-sensitive).
Enter value for directory_name: AWR_DUMP_DIR ----此處要大寫
Using the dump directory: AWR_DUMP_DIR
Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_57_65.
To use this name, press to continue, otherwise enter
an alternative.
Enter value for file_name: ------此處選擇了預設名稱awrdat_57_65
Using the dump file prefix: awrdat_57_65
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The AWR extract dump file will be located
| in the following directory/file:
| /u01/awr
| awrdat_57_65.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Extract Started ...
|
| This operation will take a few moments. The
| progress of the AWR extract operation can be
| monitored in the following directory/file:
| /u01/awr
| awrdat_57_65.log
|
Starting "SYS"."SYS_EXPORT_TABLE_01":
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 18.25 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SYS"."WRH$_SQL_PLAN" 1.344 MB 3817 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_1798964329_0" 9.468 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_1798964329_0" 23.03 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_1798964329_0" 6.117 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_1798964329_0" 6.742 KB 0 rows
. . exported "SYS"."WRH$_SQLTEXT" 335.1 KB 491 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1798964329_0" 100.3 KB 610 rows
. . exported "SYS"."WRH$_DLM_MISC":"WRH$_DLM_MI_1798964329_0" 20.83 KB 300 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_1798964329_0" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SYSMETRIC_SUMMARY" 180.0 KB 2412 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1798964329_0" 50.76 KB 684 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1798964329_0" 6.437 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1798964329_0" 6.75 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1798964329_0" 29.46 KB 363 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1798964329_0" 23.23 KB 341 rows
. . exported "SYS"."WRM$_SNAPSHOT" 9.664 KB 18 rows
. . exported "SYS"."WRH$_BG_EVENT_SUMMARY" 40.52 KB 976 rows
. . exported "SYS"."WRH$_BUFFER_POOL_STATISTICS" 13.37 KB 18 rows
. . exported "SYS"."WRH$_CR_BLOCK_SERVER" 12.64 KB 18 rows
. . exported "SYS"."WRH$_CURRENT_BLOCK_SERVER" 11.10 KB 18 rows
. . exported "SYS"."WRH$_ENQUEUE_STAT" 67.37 KB 1200 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_56" 11.10 KB 36 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_60" 13.12 KB 72 rows
. . exported "SYS"."WRH$_INSTANCE_RECOVERY" 12.39 KB 18 rows
. . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_C_1798964329_0" 10.83 KB 63 rows
. . exported "SYS"."WRH$_JAVA_POOL_ADVICE" 9.710 KB 36 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1798964329_0" 44.52 KB 617 rows
. . exported "SYS"."WRH$_LIBRARYCACHE" 19.75 KB 198 rows
. . exported "SYS"."WRH$_LOG" 12.46 KB 72 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_1798964329_0" 10.01 KB 162 rows
. . exported "SYS"."WRH$_PGASTAT" 17.99 KB 269 rows
. . exported "SYS"."WRH$_PGA_TARGET_ADVICE" 18.77 KB 252 rows
. . exported "SYS"."WRH$_PROCESS_MEMORY_SUMMARY" 12.97 KB 72 rows
. . exported "SYS"."WRH$_RESOURCE_LIMIT" 15.43 KB 144 rows
. . exported "SYS"."WRH$_SEG_STAT_OBJ" 28.97 KB 247 rows
. . exported "SYS"."WRH$_SGA" 8.734 KB 72 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_1798964329_0" 22.03 KB 340 rows
. . exported "SYS"."WRH$_SGA_TARGET_ADVICE" 10.75 KB 126 rows
. . exported "SYS"."WRH$_SHARED_POOL_ADVICE" 23.51 KB 304 rows
. . exported "SYS"."WRH$_SQL_BIND_METADATA" 79.86 KB 1292 rows
. . exported "SYS"."WRH$_SQL_SUMMARY" 7.406 KB 18 rows
. . exported "SYS"."WRH$_SQL_WORKAREA_HISTOGRAM" 10.35 KB 80 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1798964329_0" 15.72 KB 342 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1798964329_0" 14.09 KB 108 rows
. . exported "SYS"."WRH$_TEMPSTATXS" 10.13 KB 18 rows
. . exported "SYS"."WRH$_THREAD" 8.796 KB 36 rows
. . exported "SYS"."WRH$_UNDOSTAT" 20.44 KB 98 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_1798964329_0" 17.53 KB 324 rows
. . exported "SYS"."WRM$_DATABASE_INSTANCE" 7.515 KB 2 rows
. . exported "SYS"."WRM$_SNAP_ERROR" 10.89 KB 140 rows
. . exported "SYS"."WRH$_EVENT_NAME" 67.89 KB 874 rows
. . exported "SYS"."WRH$_PARAMETER_NAME" 60.15 KB 1385 rows
. . exported "SYS"."WRH$_DATAFILE" 7.507 KB 6 rows
. . exported "SYS"."WRH$_LATCH_NAME" 22.24 KB 382 rows
. . exported "SYS"."WRH$_METRIC_NAME" 24.77 KB 211 rows
. . exported "SYS"."WRH$_OPTIMIZER_ENV" 8.539 KB 18 rows
. . exported "SYS"."WRH$_OSSTAT_NAME" 5.75 KB 9 rows
. . exported "SYS"."WRH$_RULE_SET" 8.718 KB 8 rows
. . exported "SYS"."WRH$_SERVICE_NAME" 6.117 KB 8 rows
. . exported "SYS"."WRH$_SESS_TIME_STATS" 7.851 KB 16 rows
. . exported "SYS"."WRH$_STAT_NAME" 22.17 KB 380 rows
. . exported "SYS"."WRH$_STREAMS_POOL_ADVICE" 12.28 KB 160 rows
. . exported "SYS"."WRH$_TABLESPACE_SPACE_USAGE" 9.914 KB 63 rows
. . exported "SYS"."WRH$_TEMPFILE" 7.109 KB 1 rows
. . exported "SYS"."WRM$_WR_CONTROL" 10.13 KB 1 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_SES_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_BUFFERED_QUEUES" 0 KB 0 rows
. . exported "SYS"."WRH$_BUFFERED_SUBSCRIBERS" 0 KB 0 rows
. . exported "SYS"."WRH$_COMP_IOSTAT" 0 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CACHE_AD_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_DLM_MISC":"WRH$_DLM_MISC_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_DLM_MISC_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_FILEMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_CACHE_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH_MISSE_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_MTTR_TARGET_ADVICE" 0 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SESSMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_STREAMS_APPLY_SUM" 0 KB 0 rows
. . exported "SYS"."WRH$_STREAMS_CAPTURE" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITCLASSMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT_BL" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/u01/awr/awrdat_57_65.dmp ----在對應的目錄下生成匯出檔案
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 19:11:17
二，匯入AWR資訊
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 18 19:24:53 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @?/rdbms/admin/awrload.sql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer: This SQL/Plus script should only be called under
the guidance of Oracle Support.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will load the AWR data from a dump file. The ~
~ script will prompt users for the following information: ~
~ (1) name of directory object ~
~ (2) name of dump file ~
~ (3) staging schema name to load AWR data into ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
ADMIN_DIR /ade/aime_ship_10gR2_050630.0022/oracle/md/admin
AWR_DUMP_DIR /u01/awr
DATA_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/sales_history/
DATA_PUMP_DIR /u01/app/oracle/product/10.2.0/db_1/rdbms/log/
LOG_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/log/
MEDIA_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/product_media/
SUBDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/o rder_entry//2002/Sep
WORK_DIR /ade/aime_ship_10gR2_050630.0022/oracle/work
XMLDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/order_entry/
Choose a Directory Name from the list above (case-sensitive).
Enter value for directory_name: AWR_DUMP_DIR -------此處要大寫
Using the dump directory: AWR_DUMP_DIR
Specify the Name of the Dump File to Load
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please specify the prefix of the dump file (.dmp) to load:
Enter value for file_name: awrdat_57_65 ----輸入名字的時候不加字尾 .dmp
Loading from the file name: awrdat_57_65.dmp
Staging Schema to Load AWR Snapshot Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The next step is to create the staging schema
where the AWR snapshot data will be loaded.
After loading the data into the staging schema,
the data will be transferred into the AWR tables
in the SYS schema.
The default staging schema name is AWR_STAGE.
To use this name, press to continue, otherwise enter
an alternative.
Enter value for schema_name:
Using the staging schema name: AWR_STAGE ----建立臨時使用者
Choose the Default tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE users's default tablespace. This is the
tablespace in which the AWR data will be staged.
TABLESPACE_NAME CONTENTS DEFAULT TABLESPACE
------------------------------ --------- ------------------
EXAMPLE PERMANENT
SYSAUX PERMANENT *
USERS PERMANENT
Pressing will result in the recommended default
tablespace (identified by *) being used.
Enter value for default_tablespace: SYSAUX ----快照存放的表空間
Using tablespace SYSAUX as the default tablespace for the AWR_STAGE
Choose the Temporary tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE user's temporary tablespace.
TABLESPACE_NAME CONTENTS DEFAULT TEMP TABLESPACE
------------------------------ --------- -----------------------
TEMP TEMPORARY *
Pressing will result in the database's default temporary
tablespace (identified by *) being used.
Enter value for temporary_tablespace: TEMP -----使用的臨時表空間
Using tablespace TEMP as the temporary tablespace for AWR_STAGE
... Creating AWR_STAGE user
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
| /u01/awr
| awrdat_57_65.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Load Started ...
|
| This operation will take a few moments. The
| progress of the AWR load operation can be
| monitored in the following directory/file:
| /u01/awr
| awrdat_57_65.log
|
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "AWR_STAGE"."WRH$_SQL_PLAN" 1.344 MB 3817 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1798964329_0" 9.468 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1798964329_0" 23.03 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1798964329_0" 6.117 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1798964329_0" 6.742 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLTEXT" 335.1 KB 491 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1798964329_0" 100.3 KB 610 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC":"WRH$_DLM_MI_1798964329_0" 20.83 KB 300 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1798964329_0" 16.60 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_SUMMARY" 180.0 KB 2412 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1798964329_0" 50.76 KB 684 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1798964329_0" 6.437 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1798964329_0" 6.75 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1798964329_0" 29.46 KB 363 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1798964329_0" 23.23 KB 341 rows
. . imported "AWR_STAGE"."WRM$_SNAPSHOT" 9.664 KB 18 rows
. . imported "AWR_STAGE"."WRH$_BG_EVENT_SUMMARY" 40.52 KB 976 rows
. . imported "AWR_STAGE"."WRH$_BUFFER_POOL_STATISTICS" 13.37 KB 18 rows
. . imported "AWR_STAGE"."WRH$_CR_BLOCK_SERVER" 12.64 KB 18 rows
. . imported "AWR_STAGE"."WRH$_CURRENT_BLOCK_SERVER" 11.10 KB 18 rows
. . imported "AWR_STAGE"."WRH$_ENQUEUE_STAT" 67.37 KB 1200 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_56" 11.10 KB 36 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_60" 13.12 KB 72 rows
. . imported "AWR_STAGE"."WRH$_INSTANCE_RECOVERY" 12.39 KB 18 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_C_1798964329_0" 10.83 KB 63 rows
. . imported "AWR_STAGE"."WRH$_JAVA_POOL_ADVICE" 9.710 KB 36 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1798964329_0" 44.52 KB 617 rows
. . imported "AWR_STAGE"."WRH$_LIBRARYCACHE" 19.75 KB 198 rows
. . imported "AWR_STAGE"."WRH$_LOG" 12.46 KB 72 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1798964329_0" 10.01 KB 162 rows
. . imported "AWR_STAGE"."WRH$_PGASTAT" 17.99 KB 269 rows
. . imported "AWR_STAGE"."WRH$_PGA_TARGET_ADVICE" 18.77 KB 252 rows
. . imported "AWR_STAGE"."WRH$_PROCESS_MEMORY_SUMMARY" 12.97 KB 72 rows
. . imported "AWR_STAGE"."WRH$_RESOURCE_LIMIT" 15.43 KB 144 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_OBJ" 28.97 KB 247 rows
. . imported "AWR_STAGE"."WRH$_SGA" 8.734 KB 72 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1798964329_0" 22.03 KB 340 rows
. . imported "AWR_STAGE"."WRH$_SGA_TARGET_ADVICE" 10.75 KB 126 rows
. . imported "AWR_STAGE"."WRH$_SHARED_POOL_ADVICE" 23.51 KB 304 rows
. . imported "AWR_STAGE"."WRH$_SQL_BIND_METADATA" 79.86 KB 1292 rows
. . imported "AWR_STAGE"."WRH$_SQL_SUMMARY" 7.406 KB 18 rows
. . imported "AWR_STAGE"."WRH$_SQL_WORKAREA_HISTOGRAM" 10.35 KB 80 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1798964329_0" 15.72 KB 342 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1798964329_0" 14.09 KB 108 rows
. . imported "AWR_STAGE"."WRH$_TEMPSTATXS" 10.13 KB 18 rows
. . imported "AWR_STAGE"."WRH$_THREAD" 8.796 KB 36 rows
. . imported "AWR_STAGE"."WRH$_UNDOSTAT" 20.44 KB 98 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1798964329_0" 17.53 KB 324 rows
. . imported "AWR_STAGE"."WRM$_DATABASE_INSTANCE" 7.515 KB 2 rows
. . imported "AWR_STAGE"."WRM$_SNAP_ERROR" 10.89 KB 140 rows
. . imported "AWR_STAGE"."WRH$_EVENT_NAME" 67.89 KB 874 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_NAME" 60.15 KB 1385 rows
. . imported "AWR_STAGE"."WRH$_DATAFILE" 7.507 KB 6 rows
. . imported "AWR_STAGE"."WRH$_LATCH_NAME" 22.24 KB 382 rows
. . imported "AWR_STAGE"."WRH$_METRIC_NAME" 24.77 KB 211 rows
. . imported "AWR_STAGE"."WRH$_OPTIMIZER_ENV" 8.539 KB 18 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_NAME" 5.75 KB 9 rows
. . imported "AWR_STAGE"."WRH$_RULE_SET" 8.718 KB 8 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_NAME" 6.117 KB 8 rows
. . imported "AWR_STAGE"."WRH$_SESS_TIME_STATS" 7.851 KB 16 rows
. . imported "AWR_STAGE"."WRH$_STAT_NAME" 22.17 KB 380 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_POOL_ADVICE" 12.28 KB 160 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_SPACE_USAGE" 9.914 KB 63 rows
. . imported "AWR_STAGE"."WRH$_TEMPFILE" 7.109 KB 1 rows
. . imported "AWR_STAGE"."WRM$_WR_CONTROL" 10.13 KB 1 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_SES_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_QUEUES" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_SUBSCRIBERS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_COMP_IOSTAT" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CACHE_AD_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC":"WRH$_DLM_MISC_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILEMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_CACHE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH_MISSE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_MTTR_TARGET_ADVICE" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SESSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_APPLY_SUM" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_CAPTURE" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITCLASSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT_BL" 0 KB 0 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 19:30:42
Register the DBID: 1798964329
Append Data for AWR_STAGE.WRM$_DATABASE_INSTANCE.
Append Data for AWR_STAGE.WRM$_SNAPSHOT.
Append Data for AWR_STAGE.WRH$_STAT_NAME.
Append Data for AWR_STAGE.WRH$_PARAMETER_NAME.
Append Data for AWR_STAGE.WRH$_EVENT_NAME.
Append Data for AWR_STAGE.WRH$_LATCH_NAME.
Append Data for AWR_STAGE.WRH$_FILESTATXS.
Append Data for AWR_STAGE.WRH$_FILESTATXS_BL.
Append Data for AWR_STAGE.WRH$_TEMPSTATXS.
Append Data for AWR_STAGE.WRH$_DATAFILE.
Append Data for AWR_STAGE.WRH$_TEMPFILE.
Append Data for AWR_STAGE.WRH$_SQLSTAT.
Append Data for AWR_STAGE.WRH$_SQLSTAT_BL.
Append Data for AWR_STAGE.WRH$_SQLTEXT.
Append Data for AWR_STAGE.WRH$_SQL_SUMMARY.
Append Data for AWR_STAGE.WRH$_SQL_PLAN.
Append Data for AWR_STAGE.WRH$_SYSTEM_EVENT.
Append Data for AWR_STAGE.WRH$_SYSTEM_EVENT_BL.
Append Data for AWR_STAGE.WRH$_BG_EVENT_SUMMARY.
Append Data for AWR_STAGE.WRH$_WAITSTAT.
Append Data for AWR_STAGE.WRH$_WAITSTAT_BL.
Append Data for AWR_STAGE.WRH$_ENQUEUE_STAT.
Append Data for AWR_STAGE.WRH$_LATCH.
Append Data for AWR_STAGE.WRH$_LATCH_BL.
Append Data for AWR_STAGE.WRH$_LATCH_CHILDREN.
Append Data for AWR_STAGE.WRH$_LATCH_CHILDREN_BL.
Append Data for AWR_STAGE.WRH$_LATCH_PARENT.
Append Data for AWR_STAGE.WRH$_LATCH_PARENT_BL.
Append Data for AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY.
Append Data for AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY_BL.
Append Data for AWR_STAGE.WRH$_LIBRARYCACHE.
Append Data for AWR_STAGE.WRH$_DB_CACHE_ADVICE.
Append Data for AWR_STAGE.WRH$_DB_CACHE_ADVICE_BL.
Append Data for AWR_STAGE.WRH$_BUFFER_POOL_STATISTICS.
Append Data for AWR_STAGE.WRH$_ROWCACHE_SUMMARY.
Append Data for AWR_STAGE.WRH$_ROWCACHE_SUMMARY_BL.
Append Data for AWR_STAGE.WRH$_SGA.
Append Data for AWR_STAGE.WRH$_SGASTAT.
Append Data for AWR_STAGE.WRH$_SGASTAT_BL.
Append Data for AWR_STAGE.WRH$_PGASTAT.
Append Data for AWR_STAGE.WRH$_PROCESS_MEMORY_SUMMARY.
Append Data for AWR_STAGE.WRH$_RESOURCE_LIMIT.
Append Data for AWR_STAGE.WRH$_SHARED_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_SQL_WORKAREA_HISTOGRAM.
Append Data for AWR_STAGE.WRH$_PGA_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_INSTANCE_RECOVERY.
Append Data for AWR_STAGE.WRH$_SYSSTAT.
Append Data for AWR_STAGE.WRH$_SYSSTAT_BL.
Append Data for AWR_STAGE.WRH$_PARAMETER.
Append Data for AWR_STAGE.WRH$_PARAMETER_BL.
Append Data for AWR_STAGE.WRH$_UNDOSTAT.
Append Data for AWR_STAGE.WRH$_SEG_STAT.
Append Data for AWR_STAGE.WRH$_SEG_STAT_BL.
Append Data for AWR_STAGE.WRH$_SEG_STAT_OBJ.
Append Data for AWR_STAGE.WRH$_DLM_MISC.
Append Data for AWR_STAGE.WRH$_DLM_MISC_BL.
Append Data for AWR_STAGE.WRH$_SERVICE_NAME.
Append Data for AWR_STAGE.WRH$_SERVICE_STAT.
Append Data for AWR_STAGE.WRH$_SERVICE_STAT_BL.
Append Data for AWR_STAGE.WRH$_SYSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_FILEMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_WAITCLASSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_TABLESPACE_STAT.
Append Data for AWR_STAGE.WRH$_TABLESPACE_STAT_BL.
Append Data for AWR_STAGE.WRH$_LOG.
Append Data for AWR_STAGE.WRH$_MTTR_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_TABLESPACE_SPACE_USAGE.
Append Data for AWR_STAGE.WRH$_METRIC_NAME.
Append Data for AWR_STAGE.WRH$_SYSMETRIC_SUMMARY.
Append Data for AWR_STAGE.WRH$_SQL_BIND_METADATA.
Append Data for AWR_STAGE.WRH$_JAVA_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_THREAD.
Append Data for AWR_STAGE.WRH$_SESSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_OSSTAT.
Append Data for AWR_STAGE.WRH$_OSSTAT_BL.
Append Data for AWR_STAGE.WRH$_OSSTAT_NAME.
Append Data for AWR_STAGE.WRH$_SYS_TIME_MODEL.
Append Data for AWR_STAGE.WRH$_SYS_TIME_MODEL_BL.
Append Data for AWR_STAGE.WRH$_OPTIMIZER_ENV.
Append Data for AWR_STAGE.WRH$_SERVICE_WAIT_CLASS.
Append Data for AWR_STAGE.WRH$_SERVICE_WAIT_CLASS_BL.
Append Data for AWR_STAGE.WRH$_CR_BLOCK_SERVER.
Append Data for AWR_STAGE.WRH$_CURRENT_BLOCK_SERVER.
Append Data for AWR_STAGE.WRH$_INST_CACHE_TRANSFER.
Append Data for AWR_STAGE.WRH$_INST_CACHE_TRANSFER_BL.
Append Data for AWR_STAGE.WRH$_STREAMS_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_COMP_IOSTAT.
Append Data for AWR_STAGE.WRH$_SGA_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_SESS_TIME_STATS.
Append Data for AWR_STAGE.WRH$_STREAMS_CAPTURE.
Append Data for AWR_STAGE.WRH$_STREAMS_APPLY_SUM.
Append Data for AWR_STAGE.WRH$_BUFFERED_QUEUES.
Append Data for AWR_STAGE.WRH$_BUFFERED_SUBSCRIBERS.
Append Data for AWR_STAGE.WRH$_RULE_SET.
Append Data for AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY.
Append Data for AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY_BL.
Append Data for AWR_STAGE.WRM$_SNAP_ERROR.
Finished MOVE_TO_AWR procedure
... Dropping AWR_STAGE user
End of AWR Load
Last login: Thu Sep 18 19:20:41 2014 from 192.168.0.6
三，在測試機上生成生產庫的AWR報告
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 18 20:12:52 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @?/rdbms/admin/awrrpti.sql
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
------------ -------- ------------ ------------ ------------
1798964329 2 RAC10G rac10g2 rac2
1798964329 1 RAC10G rac10g1 rac1
* 4078378616 1 ORA10G ora10g ora10g
Enter value for dbid: 1798964329
Using 1798964329 for database Id
Enter value for inst_num: 1
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
------------ ------------ --------- ------------------ -----
rac10g1 RAC10G 57 18 Sep 2014 10:55 1 -----與源庫匯出的快照一致
58 18 Sep 2014 12:00 1
59 18 Sep 2014 13:04 1
60 18 Sep 2014 14:00 1
61 18 Sep 2014 15:00 1
62 18 Sep 2014 16:00 1
63 18 Sep 2014 17:00 1
64 18 Sep 2014 18:00 1
65 18 Sep 2014 19:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 57
Begin Snapshot Id specified: 57
Enter value for end_snap: 58
End Snapshot Id specified: 58
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_57_58.html. To use this name,
press to continue, otherwise enter an alternative.
.......
一，匯出AWR資訊
SQL> @?/rdbms/admin/awrextr.sql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer: This SQL/Plus script should only be called under
the guidance of Oracle Support.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~
AWR EXTRACT
~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will extract the AWR data for a range of snapshots ~
~ into a dump file. The script will prompt users for the ~
~ following information: ~
~ (1) database id ~
~ (2) snapshot range to extract ~
~ (3) name of directory object ~
~ (4) name of dump file ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Databases in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id DB Name Host
------------ ------------ ------------
* 1798964329 RAC10G rac1
* 1798964329 RAC10G rac2
The default database id is the local one: '1798964329'. To use this
database id, press
Enter value for dbid: 1798964329
Using 1798964329 for Database ID
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
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day's Completed Snapshots
DB Name Snap Id Snap Started
------------ --------- ------------------
RAC10G .. ... .....
57 18 Sep 2014 10:55
58 18 Sep 2014 12:00
59 18 Sep 2014 13:04
60 18 Sep 2014 14:00
61 18 Sep 2014 15:00
62 18 Sep 2014 16:00
63 18 Sep 2014 17:00
64 18 Sep 2014 18:00
65 18 Sep 2014 19:00
.. ... ....
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 57
Begin Snapshot Id specified: 57
Enter value for end_snap: 65
End Snapshot Id specified: 65
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
ADMIN_DIR /ade/aime_ship_10gR2_050630.0022/oracle/md/admin
AWR_DUMP_DIR /u01/awr
DATA_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/sales_history/
DATA_PUMP_DIR /u01/app/oracle/product/10.2.0/db_1/rdbms/log/
LOG_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/log/
MEDIA_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/product_media/
SUBDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/o rder_entry//2002/Sep
WORK_DIR /ade/aime_ship_10gR2_050630.0022/oracle/work
XMLDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/order_entry/
Choose a Directory Name from the above list (case-sensitive).
Enter value for directory_name: AWR_DUMP_DIR ----此處要大寫
Using the dump directory: AWR_DUMP_DIR
Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_57_65.
To use this name, press
an alternative.
Enter value for file_name: ------此處選擇了預設名稱awrdat_57_65
Using the dump file prefix: awrdat_57_65
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The AWR extract dump file will be located
| in the following directory/file:
| /u01/awr
| awrdat_57_65.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Extract Started ...
|
| This operation will take a few moments. The
| progress of the AWR extract operation can be
| monitored in the following directory/file:
| /u01/awr
| awrdat_57_65.log
|
Starting "SYS"."SYS_EXPORT_TABLE_01":
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 18.25 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SYS"."WRH$_SQL_PLAN" 1.344 MB 3817 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_1798964329_0" 9.468 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_1798964329_0" 23.03 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_1798964329_0" 6.117 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_1798964329_0" 6.742 KB 0 rows
. . exported "SYS"."WRH$_SQLTEXT" 335.1 KB 491 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1798964329_0" 100.3 KB 610 rows
. . exported "SYS"."WRH$_DLM_MISC":"WRH$_DLM_MI_1798964329_0" 20.83 KB 300 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_1798964329_0" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SYSMETRIC_SUMMARY" 180.0 KB 2412 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1798964329_0" 50.76 KB 684 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1798964329_0" 6.437 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1798964329_0" 6.75 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1798964329_0" 29.46 KB 363 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1798964329_0" 23.23 KB 341 rows
. . exported "SYS"."WRM$_SNAPSHOT" 9.664 KB 18 rows
. . exported "SYS"."WRH$_BG_EVENT_SUMMARY" 40.52 KB 976 rows
. . exported "SYS"."WRH$_BUFFER_POOL_STATISTICS" 13.37 KB 18 rows
. . exported "SYS"."WRH$_CR_BLOCK_SERVER" 12.64 KB 18 rows
. . exported "SYS"."WRH$_CURRENT_BLOCK_SERVER" 11.10 KB 18 rows
. . exported "SYS"."WRH$_ENQUEUE_STAT" 67.37 KB 1200 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_56" 11.10 KB 36 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_60" 13.12 KB 72 rows
. . exported "SYS"."WRH$_INSTANCE_RECOVERY" 12.39 KB 18 rows
. . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_C_1798964329_0" 10.83 KB 63 rows
. . exported "SYS"."WRH$_JAVA_POOL_ADVICE" 9.710 KB 36 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1798964329_0" 44.52 KB 617 rows
. . exported "SYS"."WRH$_LIBRARYCACHE" 19.75 KB 198 rows
. . exported "SYS"."WRH$_LOG" 12.46 KB 72 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_1798964329_0" 10.01 KB 162 rows
. . exported "SYS"."WRH$_PGASTAT" 17.99 KB 269 rows
. . exported "SYS"."WRH$_PGA_TARGET_ADVICE" 18.77 KB 252 rows
. . exported "SYS"."WRH$_PROCESS_MEMORY_SUMMARY" 12.97 KB 72 rows
. . exported "SYS"."WRH$_RESOURCE_LIMIT" 15.43 KB 144 rows
. . exported "SYS"."WRH$_SEG_STAT_OBJ" 28.97 KB 247 rows
. . exported "SYS"."WRH$_SGA" 8.734 KB 72 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_1798964329_0" 22.03 KB 340 rows
. . exported "SYS"."WRH$_SGA_TARGET_ADVICE" 10.75 KB 126 rows
. . exported "SYS"."WRH$_SHARED_POOL_ADVICE" 23.51 KB 304 rows
. . exported "SYS"."WRH$_SQL_BIND_METADATA" 79.86 KB 1292 rows
. . exported "SYS"."WRH$_SQL_SUMMARY" 7.406 KB 18 rows
. . exported "SYS"."WRH$_SQL_WORKAREA_HISTOGRAM" 10.35 KB 80 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1798964329_0" 15.72 KB 342 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1798964329_0" 14.09 KB 108 rows
. . exported "SYS"."WRH$_TEMPSTATXS" 10.13 KB 18 rows
. . exported "SYS"."WRH$_THREAD" 8.796 KB 36 rows
. . exported "SYS"."WRH$_UNDOSTAT" 20.44 KB 98 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_1798964329_0" 17.53 KB 324 rows
. . exported "SYS"."WRM$_DATABASE_INSTANCE" 7.515 KB 2 rows
. . exported "SYS"."WRM$_SNAP_ERROR" 10.89 KB 140 rows
. . exported "SYS"."WRH$_EVENT_NAME" 67.89 KB 874 rows
. . exported "SYS"."WRH$_PARAMETER_NAME" 60.15 KB 1385 rows
. . exported "SYS"."WRH$_DATAFILE" 7.507 KB 6 rows
. . exported "SYS"."WRH$_LATCH_NAME" 22.24 KB 382 rows
. . exported "SYS"."WRH$_METRIC_NAME" 24.77 KB 211 rows
. . exported "SYS"."WRH$_OPTIMIZER_ENV" 8.539 KB 18 rows
. . exported "SYS"."WRH$_OSSTAT_NAME" 5.75 KB 9 rows
. . exported "SYS"."WRH$_RULE_SET" 8.718 KB 8 rows
. . exported "SYS"."WRH$_SERVICE_NAME" 6.117 KB 8 rows
. . exported "SYS"."WRH$_SESS_TIME_STATS" 7.851 KB 16 rows
. . exported "SYS"."WRH$_STAT_NAME" 22.17 KB 380 rows
. . exported "SYS"."WRH$_STREAMS_POOL_ADVICE" 12.28 KB 160 rows
. . exported "SYS"."WRH$_TABLESPACE_SPACE_USAGE" 9.914 KB 63 rows
. . exported "SYS"."WRH$_TEMPFILE" 7.109 KB 1 rows
. . exported "SYS"."WRM$_WR_CONTROL" 10.13 KB 1 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_SES_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_BUFFERED_QUEUES" 0 KB 0 rows
. . exported "SYS"."WRH$_BUFFERED_SUBSCRIBERS" 0 KB 0 rows
. . exported "SYS"."WRH$_COMP_IOSTAT" 0 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CACHE_AD_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_DLM_MISC":"WRH$_DLM_MISC_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_DLM_MISC_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_FILEMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_CACHE_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_CHILDREN_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH_MISSE_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . exported "SYS"."WRH$_LATCH_PARENT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_MTTR_TARGET_ADVICE" 0 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SESSMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SGASTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_STREAMS_APPLY_SUM" 0 KB 0 rows
. . exported "SYS"."WRH$_STREAMS_CAPTURE" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT_BL" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITCLASSMETRIC_HISTORY" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN" 0 KB 0 rows
. . exported "SYS"."WRH$_WAITSTAT_BL" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/u01/awr/awrdat_57_65.dmp ----在對應的目錄下生成匯出檔案
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 19:11:17
二，匯入AWR資訊
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 18 19:24:53 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @?/rdbms/admin/awrload.sql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer: This SQL/Plus script should only be called under
the guidance of Oracle Support.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will load the AWR data from a dump file. The ~
~ script will prompt users for the following information: ~
~ (1) name of directory object ~
~ (2) name of dump file ~
~ (3) staging schema name to load AWR data into ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
ADMIN_DIR /ade/aime_ship_10gR2_050630.0022/oracle/md/admin
AWR_DUMP_DIR /u01/awr
DATA_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/sales_history/
DATA_PUMP_DIR /u01/app/oracle/product/10.2.0/db_1/rdbms/log/
LOG_FILE_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/log/
MEDIA_DIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/product_media/
SUBDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/o rder_entry//2002/Sep
WORK_DIR /ade/aime_ship_10gR2_050630.0022/oracle/work
XMLDIR /u01/app/oracle/product/10.2.0/db_1/demo/schema/order_entry/
Choose a Directory Name from the list above (case-sensitive).
Enter value for directory_name: AWR_DUMP_DIR -------此處要大寫
Using the dump directory: AWR_DUMP_DIR
Specify the Name of the Dump File to Load
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please specify the prefix of the dump file (.dmp) to load:
Enter value for file_name: awrdat_57_65 ----輸入名字的時候不加字尾 .dmp
Loading from the file name: awrdat_57_65.dmp
Staging Schema to Load AWR Snapshot Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The next step is to create the staging schema
where the AWR snapshot data will be loaded.
After loading the data into the staging schema,
the data will be transferred into the AWR tables
in the SYS schema.
The default staging schema name is AWR_STAGE.
To use this name, press
an alternative.
Enter value for schema_name:
Using the staging schema name: AWR_STAGE ----建立臨時使用者
Choose the Default tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE users's default tablespace. This is the
tablespace in which the AWR data will be staged.
TABLESPACE_NAME CONTENTS DEFAULT TABLESPACE
------------------------------ --------- ------------------
EXAMPLE PERMANENT
SYSAUX PERMANENT *
USERS PERMANENT
Pressing
tablespace (identified by *) being used.
Enter value for default_tablespace: SYSAUX ----快照存放的表空間
Using tablespace SYSAUX as the default tablespace for the AWR_STAGE
Choose the Temporary tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE user's temporary tablespace.
TABLESPACE_NAME CONTENTS DEFAULT TEMP TABLESPACE
------------------------------ --------- -----------------------
TEMP TEMPORARY *
Pressing
tablespace (identified by *) being used.
Enter value for temporary_tablespace: TEMP -----使用的臨時表空間
Using tablespace TEMP as the temporary tablespace for AWR_STAGE
... Creating AWR_STAGE user
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
| /u01/awr
| awrdat_57_65.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Load Started ...
|
| This operation will take a few moments. The
| progress of the AWR load operation can be
| monitored in the following directory/file:
| /u01/awr
| awrdat_57_65.log
|
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "AWR_STAGE"."WRH$_SQL_PLAN" 1.344 MB 3817 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1798964329_0" 9.468 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1798964329_0" 23.03 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1798964329_0" 6.117 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1798964329_0" 6.742 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLTEXT" 335.1 KB 491 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1798964329_0" 100.3 KB 610 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC":"WRH$_DLM_MI_1798964329_0" 20.83 KB 300 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1798964329_0" 16.60 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_SUMMARY" 180.0 KB 2412 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1798964329_0" 50.76 KB 684 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1798964329_0" 6.437 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1798964329_0" 6.75 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1798964329_0" 29.46 KB 363 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1798964329_0" 23.23 KB 341 rows
. . imported "AWR_STAGE"."WRM$_SNAPSHOT" 9.664 KB 18 rows
. . imported "AWR_STAGE"."WRH$_BG_EVENT_SUMMARY" 40.52 KB 976 rows
. . imported "AWR_STAGE"."WRH$_BUFFER_POOL_STATISTICS" 13.37 KB 18 rows
. . imported "AWR_STAGE"."WRH$_CR_BLOCK_SERVER" 12.64 KB 18 rows
. . imported "AWR_STAGE"."WRH$_CURRENT_BLOCK_SERVER" 11.10 KB 18 rows
. . imported "AWR_STAGE"."WRH$_ENQUEUE_STAT" 67.37 KB 1200 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_56" 11.10 KB 36 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1798964329_60" 13.12 KB 72 rows
. . imported "AWR_STAGE"."WRH$_INSTANCE_RECOVERY" 12.39 KB 18 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_C_1798964329_0" 10.83 KB 63 rows
. . imported "AWR_STAGE"."WRH$_JAVA_POOL_ADVICE" 9.710 KB 36 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1798964329_0" 44.52 KB 617 rows
. . imported "AWR_STAGE"."WRH$_LIBRARYCACHE" 19.75 KB 198 rows
. . imported "AWR_STAGE"."WRH$_LOG" 12.46 KB 72 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1798964329_0" 10.01 KB 162 rows
. . imported "AWR_STAGE"."WRH$_PGASTAT" 17.99 KB 269 rows
. . imported "AWR_STAGE"."WRH$_PGA_TARGET_ADVICE" 18.77 KB 252 rows
. . imported "AWR_STAGE"."WRH$_PROCESS_MEMORY_SUMMARY" 12.97 KB 72 rows
. . imported "AWR_STAGE"."WRH$_RESOURCE_LIMIT" 15.43 KB 144 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_OBJ" 28.97 KB 247 rows
. . imported "AWR_STAGE"."WRH$_SGA" 8.734 KB 72 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1798964329_0" 22.03 KB 340 rows
. . imported "AWR_STAGE"."WRH$_SGA_TARGET_ADVICE" 10.75 KB 126 rows
. . imported "AWR_STAGE"."WRH$_SHARED_POOL_ADVICE" 23.51 KB 304 rows
. . imported "AWR_STAGE"."WRH$_SQL_BIND_METADATA" 79.86 KB 1292 rows
. . imported "AWR_STAGE"."WRH$_SQL_SUMMARY" 7.406 KB 18 rows
. . imported "AWR_STAGE"."WRH$_SQL_WORKAREA_HISTOGRAM" 10.35 KB 80 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1798964329_0" 15.72 KB 342 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1798964329_0" 14.09 KB 108 rows
. . imported "AWR_STAGE"."WRH$_TEMPSTATXS" 10.13 KB 18 rows
. . imported "AWR_STAGE"."WRH$_THREAD" 8.796 KB 36 rows
. . imported "AWR_STAGE"."WRH$_UNDOSTAT" 20.44 KB 98 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1798964329_0" 17.53 KB 324 rows
. . imported "AWR_STAGE"."WRM$_DATABASE_INSTANCE" 7.515 KB 2 rows
. . imported "AWR_STAGE"."WRM$_SNAP_ERROR" 10.89 KB 140 rows
. . imported "AWR_STAGE"."WRH$_EVENT_NAME" 67.89 KB 874 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_NAME" 60.15 KB 1385 rows
. . imported "AWR_STAGE"."WRH$_DATAFILE" 7.507 KB 6 rows
. . imported "AWR_STAGE"."WRH$_LATCH_NAME" 22.24 KB 382 rows
. . imported "AWR_STAGE"."WRH$_METRIC_NAME" 24.77 KB 211 rows
. . imported "AWR_STAGE"."WRH$_OPTIMIZER_ENV" 8.539 KB 18 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_NAME" 5.75 KB 9 rows
. . imported "AWR_STAGE"."WRH$_RULE_SET" 8.718 KB 8 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_NAME" 6.117 KB 8 rows
. . imported "AWR_STAGE"."WRH$_SESS_TIME_STATS" 7.851 KB 16 rows
. . imported "AWR_STAGE"."WRH$_STAT_NAME" 22.17 KB 380 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_POOL_ADVICE" 12.28 KB 160 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_SPACE_USAGE" 9.914 KB 63 rows
. . imported "AWR_STAGE"."WRH$_TEMPFILE" 7.109 KB 1 rows
. . imported "AWR_STAGE"."WRM$_WR_CONTROL" 10.13 KB 1 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_SES_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_QUEUES" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_BUFFERED_SUBSCRIBERS" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_COMP_IOSTAT" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CACHE_AD_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DB_CACHE_ADVICE_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC":"WRH$_DLM_MISC_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_DLM_MISC_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILEMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_FILESTATXS_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_CACHE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_CHILDREN_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH_MISSE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT":"WRH$_LATCH__1798964329_0" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_LATCH_PARENT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_MTTR_TARGET_ADVICE" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_PARAMETER_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_ROWCACHE_SUMMARY_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SESSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SGASTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SQLSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_APPLY_SUM" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_STREAMS_CAPTURE" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSTEM_EVENT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYS_TIME_MODEL_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_STAT_BL" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITCLASSMETRIC_HISTORY" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN" 0 KB 0 rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT_BL" 0 KB 0 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 19:30:42
Register the DBID: 1798964329
Append Data for AWR_STAGE.WRM$_DATABASE_INSTANCE.
Append Data for AWR_STAGE.WRM$_SNAPSHOT.
Append Data for AWR_STAGE.WRH$_STAT_NAME.
Append Data for AWR_STAGE.WRH$_PARAMETER_NAME.
Append Data for AWR_STAGE.WRH$_EVENT_NAME.
Append Data for AWR_STAGE.WRH$_LATCH_NAME.
Append Data for AWR_STAGE.WRH$_FILESTATXS.
Append Data for AWR_STAGE.WRH$_FILESTATXS_BL.
Append Data for AWR_STAGE.WRH$_TEMPSTATXS.
Append Data for AWR_STAGE.WRH$_DATAFILE.
Append Data for AWR_STAGE.WRH$_TEMPFILE.
Append Data for AWR_STAGE.WRH$_SQLSTAT.
Append Data for AWR_STAGE.WRH$_SQLSTAT_BL.
Append Data for AWR_STAGE.WRH$_SQLTEXT.
Append Data for AWR_STAGE.WRH$_SQL_SUMMARY.
Append Data for AWR_STAGE.WRH$_SQL_PLAN.
Append Data for AWR_STAGE.WRH$_SYSTEM_EVENT.
Append Data for AWR_STAGE.WRH$_SYSTEM_EVENT_BL.
Append Data for AWR_STAGE.WRH$_BG_EVENT_SUMMARY.
Append Data for AWR_STAGE.WRH$_WAITSTAT.
Append Data for AWR_STAGE.WRH$_WAITSTAT_BL.
Append Data for AWR_STAGE.WRH$_ENQUEUE_STAT.
Append Data for AWR_STAGE.WRH$_LATCH.
Append Data for AWR_STAGE.WRH$_LATCH_BL.
Append Data for AWR_STAGE.WRH$_LATCH_CHILDREN.
Append Data for AWR_STAGE.WRH$_LATCH_CHILDREN_BL.
Append Data for AWR_STAGE.WRH$_LATCH_PARENT.
Append Data for AWR_STAGE.WRH$_LATCH_PARENT_BL.
Append Data for AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY.
Append Data for AWR_STAGE.WRH$_LATCH_MISSES_SUMMARY_BL.
Append Data for AWR_STAGE.WRH$_LIBRARYCACHE.
Append Data for AWR_STAGE.WRH$_DB_CACHE_ADVICE.
Append Data for AWR_STAGE.WRH$_DB_CACHE_ADVICE_BL.
Append Data for AWR_STAGE.WRH$_BUFFER_POOL_STATISTICS.
Append Data for AWR_STAGE.WRH$_ROWCACHE_SUMMARY.
Append Data for AWR_STAGE.WRH$_ROWCACHE_SUMMARY_BL.
Append Data for AWR_STAGE.WRH$_SGA.
Append Data for AWR_STAGE.WRH$_SGASTAT.
Append Data for AWR_STAGE.WRH$_SGASTAT_BL.
Append Data for AWR_STAGE.WRH$_PGASTAT.
Append Data for AWR_STAGE.WRH$_PROCESS_MEMORY_SUMMARY.
Append Data for AWR_STAGE.WRH$_RESOURCE_LIMIT.
Append Data for AWR_STAGE.WRH$_SHARED_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_SQL_WORKAREA_HISTOGRAM.
Append Data for AWR_STAGE.WRH$_PGA_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_INSTANCE_RECOVERY.
Append Data for AWR_STAGE.WRH$_SYSSTAT.
Append Data for AWR_STAGE.WRH$_SYSSTAT_BL.
Append Data for AWR_STAGE.WRH$_PARAMETER.
Append Data for AWR_STAGE.WRH$_PARAMETER_BL.
Append Data for AWR_STAGE.WRH$_UNDOSTAT.
Append Data for AWR_STAGE.WRH$_SEG_STAT.
Append Data for AWR_STAGE.WRH$_SEG_STAT_BL.
Append Data for AWR_STAGE.WRH$_SEG_STAT_OBJ.
Append Data for AWR_STAGE.WRH$_DLM_MISC.
Append Data for AWR_STAGE.WRH$_DLM_MISC_BL.
Append Data for AWR_STAGE.WRH$_SERVICE_NAME.
Append Data for AWR_STAGE.WRH$_SERVICE_STAT.
Append Data for AWR_STAGE.WRH$_SERVICE_STAT_BL.
Append Data for AWR_STAGE.WRH$_SYSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_FILEMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_WAITCLASSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_TABLESPACE_STAT.
Append Data for AWR_STAGE.WRH$_TABLESPACE_STAT_BL.
Append Data for AWR_STAGE.WRH$_LOG.
Append Data for AWR_STAGE.WRH$_MTTR_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_TABLESPACE_SPACE_USAGE.
Append Data for AWR_STAGE.WRH$_METRIC_NAME.
Append Data for AWR_STAGE.WRH$_SYSMETRIC_SUMMARY.
Append Data for AWR_STAGE.WRH$_SQL_BIND_METADATA.
Append Data for AWR_STAGE.WRH$_JAVA_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_THREAD.
Append Data for AWR_STAGE.WRH$_SESSMETRIC_HISTORY.
Append Data for AWR_STAGE.WRH$_OSSTAT.
Append Data for AWR_STAGE.WRH$_OSSTAT_BL.
Append Data for AWR_STAGE.WRH$_OSSTAT_NAME.
Append Data for AWR_STAGE.WRH$_SYS_TIME_MODEL.
Append Data for AWR_STAGE.WRH$_SYS_TIME_MODEL_BL.
Append Data for AWR_STAGE.WRH$_OPTIMIZER_ENV.
Append Data for AWR_STAGE.WRH$_SERVICE_WAIT_CLASS.
Append Data for AWR_STAGE.WRH$_SERVICE_WAIT_CLASS_BL.
Append Data for AWR_STAGE.WRH$_CR_BLOCK_SERVER.
Append Data for AWR_STAGE.WRH$_CURRENT_BLOCK_SERVER.
Append Data for AWR_STAGE.WRH$_INST_CACHE_TRANSFER.
Append Data for AWR_STAGE.WRH$_INST_CACHE_TRANSFER_BL.
Append Data for AWR_STAGE.WRH$_STREAMS_POOL_ADVICE.
Append Data for AWR_STAGE.WRH$_COMP_IOSTAT.
Append Data for AWR_STAGE.WRH$_SGA_TARGET_ADVICE.
Append Data for AWR_STAGE.WRH$_SESS_TIME_STATS.
Append Data for AWR_STAGE.WRH$_STREAMS_CAPTURE.
Append Data for AWR_STAGE.WRH$_STREAMS_APPLY_SUM.
Append Data for AWR_STAGE.WRH$_BUFFERED_QUEUES.
Append Data for AWR_STAGE.WRH$_BUFFERED_SUBSCRIBERS.
Append Data for AWR_STAGE.WRH$_RULE_SET.
Append Data for AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY.
Append Data for AWR_STAGE.WRH$_ACTIVE_SESSION_HISTORY_BL.
Append Data for AWR_STAGE.WRM$_SNAP_ERROR.
Finished MOVE_TO_AWR procedure
... Dropping AWR_STAGE user
End of AWR Load
Last login: Thu Sep 18 19:20:41 2014 from 192.168.0.6
三，在測試機上生成生產庫的AWR報告
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 18 20:12:52 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @?/rdbms/admin/awrrpti.sql
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
------------ -------- ------------ ------------ ------------
1798964329 2 RAC10G rac10g2 rac2
1798964329 1 RAC10G rac10g1 rac1
* 4078378616 1 ORA10G ora10g ora10g
Enter value for dbid: 1798964329
Using 1798964329 for database Id
Enter value for inst_num: 1
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
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
------------ ------------ --------- ------------------ -----
rac10g1 RAC10G 57 18 Sep 2014 10:55 1 -----與源庫匯出的快照一致
58 18 Sep 2014 12:00 1
59 18 Sep 2014 13:04 1
60 18 Sep 2014 14:00 1
61 18 Sep 2014 15:00 1
62 18 Sep 2014 16:00 1
63 18 Sep 2014 17:00 1
64 18 Sep 2014 18:00 1
65 18 Sep 2014 19:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 57
Begin Snapshot Id specified: 57
Enter value for end_snap: 58
End Snapshot Id specified: 58
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_57_58.html. To use this name,
press
.......
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25373498/viewspace-1276784/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 匯入和匯出AWR的資料
- Oracle AWR 資料匯入/匯出的步驟Oracle
- AWR跨庫匯出與匯入
- AWR資料的匯出和匯入全過程
- oracle10g匯出與匯入awrOracle
- Mongodb資料的匯出與匯入MongoDB
- MongoDB資料匯入與匯出MongoDB
- MySQL表資料匯入與匯出MySql
- xml與資料庫中資料的匯入匯出XML資料庫
- 資料庫的匯入匯出資料庫
- 資料泵的匯入匯出
- 資料泵匯出匯入
- Oracle 資料匯入匯出Oracle
- mysql資料匯入匯出MySql
- mysql資料匯出匯入MySql
- oracle資料匯入匯出Oracle
- DB2資料庫匯出表結構與匯入、匯出表資料DB2資料庫
- EasyPoi, Excel資料的匯入匯出Excel
- BCP 資料的匯入和匯出
- ITDS資料匯入匯出的方法
- NDS的資料匯入和匯出
- Progress資料表的匯入匯出
- 資料庫 MySQL 資料匯入匯出資料庫MySql
- sqoop資料匯入匯出OOP
- 資料匯入匯出EXP/IMP
- mysqldump匯入匯出表資料MySql
- exp/imp匯出匯入資料
- postgresql 資料匯入和匯出SQL
- mysql 資料庫匯入匯出MySql資料庫
- 資料泵匯出匯入表
- MySQL資料庫匯入匯出MySql資料庫
- MySQL資料匯入匯出方法與工具介紹MySql
- Oracle資料庫匯入匯出。imp匯入命令和exp匯出命令Oracle資料庫
- SQL資料庫的匯入和匯出SQL資料庫
- Oracle資料泵的匯入和匯出Oracle
- oracle資料的匯入匯出imp/expOracle
- 【MySQL】白話說MySQL(五)，資料的匯出與匯入MySql
- MySQL入門--匯出和匯入資料MySql