ORACLE AWR报告数据的导入导出实践
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ORACLE AWR报告数据的导入导出实践，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含30699字，纯文字阅读大概需要44分钟。
内容图文
should only be called underthe 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
------------ ------------ ------------
* 3990839260 SCM2 localhost
.localhost.com
The default database id is the local one: ‘3990839260‘. To use this
database id, press <return> to continue, otherwise enter an alternative.
Enter value for dbid: Using 3990839260 for Database IDSpecify 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> withoutspecifying a number lists all completed snapshots.
Enter value for num_days: 2Listing the last 2 days of Completed Snapshots
DB Name Snap Id Snap Started
------------ --------- ------------------
SCM2 59907 19 Jul 2016 00:00
59908 19 Jul 2016 01:00
59909 19 Jul 2016 02:00
59910 19 Jul 2016 03:00
59911 19 Jul 2016 04:00
59912 19 Jul 2016 05:00
59913 19 Jul 2016 06:00
59914 19 Jul 2016 07:00
59915 19 Jul 2016 08:00
59916 19 Jul 2016 09:00
59917 19 Jul 2016 10:00
DB Name Snap Id Snap Started
------------ --------- ------------------
SCM2 59918 19 Jul 2016 11:00
59919 19 Jul 2016 12:00
59920 19 Jul 2016 13:00
59921 19 Jul 2016 14:00
59922 19 Jul 2016 15:00
59923 19 Jul 2016 16:00
59924 19 Jul 2016 17:00
59925 19 Jul 2016 18:00
59926 19 Jul 2016 19:00
59927 19 Jul 2016 20:00
59928 19 Jul 2016 21:00
DB Name Snap Id Snap Started
------------ --------- ------------------
SCM2 59929 19 Jul 2016 22:00
59930 19 Jul 2016 23:00
59931 20 Jul 2016 00:00
59932 20 Jul 2016 01:00
59933 20 Jul 2016 02:00
59934 20 Jul 2016 03:00
59935 20 Jul 2016 04:00
59936 20 Jul 2016 05:00
59937 20 Jul 2016 06:00
59938 20 Jul 2016 07:00
59939 20 Jul 2016 08:00
DB Name Snap Id Snap Started
------------ --------- ------------------
SCM2 59940 20 Jul 2016 09:01
59941 20 Jul 2016 10:00
59942 20 Jul 2016 11:00
59943 20 Jul 2016 12:00
59944 20 Jul 2016 13:00
59945 20 Jul 2016 14:00
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 59940Begin Snapshot Id specified: 59940
Enter value for end_snap: 59945End Snapshot Id specified: 59945
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
ARCH_DATA /u01/app/oracle/dump
DATAPUMP /u02/backup/datapump
DATA_PUMP_DIR /u01/app/oracle/product/10.2.0/db_1/rdbms/log/
DUMPDIR /home/oraescm/dump
DUMP_DIR /u05/dump
PUMP_DIR /u02/dump4migrate
WORK_DIR /ade/aime_10.2_lnx_push/oracle/work
Choose a Directory Name from the above list (case-sensitive).
Enter value for directory_name: DUMP_DIRDUMP_DIR Using the dump directory: DUMP_DIR
Specify the Name of the Extract Dump File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The prefix for the default dump file name is awrdat_59940_59945.
To use this name, press <return> to continue, otherwise enter
an alternative.
Enter value for file_name: awr_out.dmpUsing the dump file prefix: awr_out.dmp
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The AWR extract dump file will be located
| in the following directory/file:| /u05/dump
| awr_out.dmp.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:| /u05/dump
| awr_out.dmp.log
|
WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260 AND SNAP_ID >=
59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)
Added filter [WHERE DBID = 3990839260] for table WRH$_STAT_NAME
Added filter [WHERE DBID = 3990839260] for table WRH$_PARAMETER_NAME
Added filter [WHERE DBID = 3990839260] for table WRH$_EVENT_NAME
Added filter [WHERE DBID = 3990839260] for table WRH$_LATCH_NAME
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_FILESTATXS_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_FILESTATXSAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_TEMPSTATXSAdded filter [WHERE DBID = 3990839260] for table WRH$_DATAFILE
Added filter [WHERE DBID = 3990839260] for table WRH$_TEMPFILE
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SQLSTAT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SQLSTATAdded filter [ WHERE (DBID, SQL_ID) IN (SELECT DBID, SQL_ID FROM SYS.WRH$_SQLSTAT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945)] for table WRH$_SQLTEXTAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SQL_SUMMARYAdded filter [ WHERE (DBID, SQL_ID, PLAN_HASH_VALUE) IN (SELECT DBID, SQL_ID, PLAN_HASH_VALUE FROMSYS.WRH$_SQLSTAT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945)] for table WRH$_SQL_PLANAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SYSTEM_EVENT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SYSTEM_EVENTAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BG_EVENT_SUMMARYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_WAITSTAT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_WAITSTATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_ENQUEUE_STATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_LATCH_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_LATCHAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_LATCH_CHILDREN_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_LATCH_CHILDRENAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_LATCH_PARENT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_LATCH_PARENTAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for tableWRH$_LATCH_MISSES_SUMMARY_BL
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for tableWRH$_LATCH_MISSES_SUMMARY
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_LIBRARYCACHEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for tableWRH$_DB_CACHE_ADVICE_BL
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_DB_CACHE_ADVICEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BUFFER_POOL_STATISTICSAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for tableWRH$_ROWCACHE_SUMMARY_BL
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_ROWCACHE_SUMMARYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SGAAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SGASTAT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SGASTATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_PGASTATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_PROCESS_MEMORY_SUMMARYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_RESOURCE_LIMITAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SHARED_POOL_ADVICEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SQL_WORKAREA_HISTOGRAMAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_PGA_TARGET_ADVICEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_INSTANCE_RECOVERYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SYSSTAT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SYSSTATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_PARAMETER_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_PARAMETERAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_UNDOSTATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SEG_STAT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SEG_STATAdded filter [WHERE DBID = 3990839260] for table WRH$_SEG_STAT_OBJ
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_DLM_MISC_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_DLM_MISCAdded filter [WHERE DBID = 3990839260] for table WRH$_SERVICE_NAME
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SERVICE_STAT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SERVICE_STATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SYSMETRIC_HISTORYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_FILEMETRIC_HISTORYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_WAITCLASSMETRIC_HISTORYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for tableWRH$_TABLESPACE_STAT_BL
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_TABLESPACE_STATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_LOGAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_MTTR_TARGET_ADVICEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_TABLESPACE_SPACE_USAGEAdded filter [WHERE DBID = 3990839260] for table WRH$_METRIC_NAME
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SYSMETRIC_SUMMARYAdded filter [WHERE DBID = 3990839260] for table WRH$_SQL_BIND_METADATA
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_JAVA_POOL_ADVICEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_THREADAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SESSMETRIC_HISTORYAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_OSSTAT_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_OSSTATAdded filter [WHERE DBID = 3990839260] for table WRH$_OSSTAT_NAME
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for table WRH$_SYS_TIME_MODEL_BLAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for table WRH$_SYS_TIME_MODELAdded filter [WHERE DBID = 3990839260] for table WRH$_OPTIMIZER_ENV
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for tableWRH$_SERVICE_WAIT_CLASS_BL
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for tableWRH$_SERVICE_WAIT_CLASS
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_CR_BLOCK_SERVERAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_CURRENT_BLOCK_SERVERAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for tableWRH$_INST_CACHE_TRANSFER_BL
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for tableWRH$_INST_CACHE_TRANSFER
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_STREAMS_POOL_ADVICEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_COMP_IOSTATAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SGA_TARGET_ADVICEAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_SESS_TIME_STATSAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_STREAMS_CAPTUREAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_STREAMS_APPLY_SUMAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BUFFERED_QUEUESAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_BUFFERED_SUBSCRIBERSAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0)] for table WRH$_RULE_SETAdded filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 1)] for tableWRH$_ACTIVE_SESSION_HISTORY_BL
Added filter [WHERE (dbid, snap_id) IN (SELECT dbid, snap_id FROM SYS.WRM$_SNAPSHOT WHERE DBID = 3990839260AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS = 0 AND BL_MOVED = 0)] for tableWRH$_ACTIVE_SESSION_HISTORY
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: 17.66 GB
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/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SYS"."WRH$_SQL_PLAN" 4.294 MB 11010 rows
. . exported "SYS"."WRH$_SQLTEXT" 2.090 MB 267 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY_BL" 17.58 KB 0 rows
. . exported "SYS"."WRH$_SQL_BIND_METADATA" 28.31 MB 445685 rows
. . exported "SYS"."WRH$_SQLSTAT_BL" 23.03 KB 0 rows
. . exported "SYS"."WRH$_LATCH_BL" 9.468 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT_OBJ" 16.81 MB 169106 rows
. . exported "SYS"."WRH$_SEG_STAT_BL" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SYSMETRIC_SUMMARY" 70.07 KB 810 rows
. . exported "SYS"."WRH$_PARAMETER_BL" 6.742 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT_BL" 6.117 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY_BL" 7.070 KB 0 rows
. . exported "SYS"."WRH$_ENQUEUE_STAT" 30.50 KB 426 rows
. . exported "SYS"."WRH$_SYSTEM_EVENT_BL" 6.75 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS_BL" 9.179 KB 0 rows
. . exported "SYS"."WRH$_SERVICE_STAT_BL" 6.429 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59596" 17.57 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59692" 17.57 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59749" 17.57 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59797" 17.57 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59845" 17.57 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59893" 45.37 KB 136 rows
. . exported "SYS"."WRH$_ROWCACHE_SUMMARY_BL" 9.5 KB 0 rows
. . exported "SYS"."WRH$_TABLESPACE_SPACE_USAGE" 17.85 KB 210 rows
. . exported "SYS"."WRH$_TABLESPACE_STAT_BL" 7.671 KB 0 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59644" 17.57 KB 0 rows
. . exported "SYS"."WRH$_BG_EVENT_SUMMARY" 14.00 KB 192 rows
. . exported "SYS"."WRH$_DB_CACHE_ADVICE_BL" 8.617 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59596" 9.468 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59644" 9.468 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59692" 9.468 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59749" 9.468 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59797" 9.468 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59845" 9.468 KB 0 rows
. . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3990839260_59893" 30.12 KB 395 rows
. . exported "SYS"."WRH$_LIBRARYCACHE" 13.16 KB 66 rows
. . exported "SYS"."WRH$_PGASTAT" 11.07 KB 102 rows
. . exported "SYS"."WRH$_PGA_TARGET_ADVICE" 12.16 KB 84 rows
. . exported "SYS"."WRH$_SERVICE_WAIT_CLASS_BL" 7.062 KB 0 rows
. . exported "SYS"."WRH$_SHARED_POOL_ADVICE" 15.49 KB 111 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59596" 23.02 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59644" 23.02 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59692" 23.02 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59749" 23.02 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59797" 23.02 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59845" 23.02 KB 0 rows
. . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3990839260_59893" 54.11 KB 122 rows
. . exported "SYS"."WRH$_SQL_WORKAREA_HISTOGRAM" 11.61 KB 96 rows
. . exported "SYS"."WRH$_SGASTAT_BL" 6.421 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59692" 16.60 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59692" 7.062 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59596" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59644" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59749" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59797" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59893" 30.90 KB 124 rows
. . exported "SYS"."WRH$_WAITSTAT_BL" 6.421 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59749" 7.062 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59797" 7.062 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59845" 7.062 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59893" 21.11 KB 227 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59692" 6.742 KB 0 rows
. . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3990839260_59845" 16.60 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59692" 6.117 KB 0 rows
. . exported "SYS"."WRH$_SYS_TIME_MODEL_BL" 6.125 KB 0 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59644" 7.062 KB 0 rows
. . exported "SYS"."WRH$_STREAMS_POOL_ADVICE" 11.39 KB 120 rows
. . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3990839260_59596" 7.062 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59596" 6.742 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59644" 6.742 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59749" 6.742 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59797" 6.742 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59845" 6.742 KB 0 rows
. . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3990839260_59893" 18.04 KB 270 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59596" 6.117 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59644" 6.117 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59749" 6.117 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59797" 6.117 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59845" 6.117 KB 0 rows
. . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3990839260_59893" 17.52 KB 388 rows
. . exported "SYS"."WRH$_LOG" 10.60 KB 36 rows
. . exported "SYS"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_3990839260_59941" 361.1 KB 1640 rows
. . exported "SYS"."WRH$_PROCESS_MEMORY_SUMMARY" 9.75 KB 24 rows
. . exported "SYS"."WRH$_RESOURCE_LIMIT" 8.914 KB 30 rows
. . exported "SYS"."WRH$_SGA_TARGET_ADVICE" 8.179 KB 45 rows
. . exported "SYS"."WRH$_TEMPSTATXS" 10.06 KB 12 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59692" 9.171 KB 0 rows
. . exported "SYS"."WRH$_OSSTAT_BL" 6.117 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59596" 9.171 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59644" 9.171 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59749" 9.171 KB 0 rows
. . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3990839260_59797" 9.171 KB 0 rows
. . exported "SYS".<span style="co
本文系统来源：http://www.cnblogs.com/kerrycode/p/5689904.html
内容总结
以上是互联网集市为您收集整理的ORACLE AWR报告数据的导入导出实践全部内容，希望文章能够帮你解决ORACLE AWR报告数据的导入导出实践所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】