ORACLE AWR报告数据的导入导出实践

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

------------ ------------ ------------

* 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 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 <return> without

specifying a number lists all completed snapshots.

Enter value for num_days: 2

Listing 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: 59940

Begin Snapshot Id specified: 59940

Enter value for end_snap: 59945

End   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.dmp

Using 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0 AND BL_MOVED = 1)] for table WRH$_FILESTATXS_BL

Added filter [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 = 0)] for table WRH$_FILESTATXS

Added filter [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)] for table WRH$_TEMPSTATXS

Added 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0 AND BL_MOVED = 1)] for table WRH$_SQLSTAT_BL

Added filter [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 = 0)] for table WRH$_SQLSTAT

Added filter [ WHERE (DBID, SQL_ID) IN (SELECT DBID, SQL_ID    FROM SYS.WRH$_SQLSTAT WHERE DBID = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945)] for table WRH$_SQLTEXT

Added filter [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)] for table WRH$_SQL_SUMMARY

Added filter [ WHERE (DBID, SQL_ID, PLAN_HASH_VALUE) IN (SELECT DBID, SQL_ID, PLAN_HASH_VALUE  FROM

SYS.WRH$_SQLSTAT WHERE DBID = 3990839260 AND SNAP_ID >= 59940 AND SNAP_ID <= 59945)] for table WRH$_SQL_PLAN

Added filter [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)] for table WRH$_SYSTEM_EVENT_BL

Added filter [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 = 0)] for table WRH$_SYSTEM_EVENT

Added filter [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)] for table WRH$_BG_EVENT_SUMMARY

Added filter [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)] for table WRH$_WAITSTAT_BL

Added filter [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 = 0)] for table WRH$_WAITSTAT

Added filter [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)] for table WRH$_ENQUEUE_STAT

Added filter [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)] for table WRH$_LATCH_BL

Added filter [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 = 0)] for table WRH$_LATCH

Added filter [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)] for table WRH$_LATCH_CHILDREN_BL

Added filter [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 = 0)] for table WRH$_LATCH_CHILDREN

Added filter [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)] for table WRH$_LATCH_PARENT_BL

Added filter [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 = 0)] for table WRH$_LATCH_PARENT

Added filter [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)] for table

WRH$_LATCH_MISSES_SUMMARY_BL

Added filter [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 = 0)] for table

WRH$_LATCH_MISSES_SUMMARY

Added filter [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)] for table WRH$_LIBRARYCACHE

Added filter [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)] for table

WRH$_DB_CACHE_ADVICE_BL

Added filter [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 = 0)] for table WRH$_DB_CACHE_ADVICE

Added filter [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)] for table WRH$_BUFFER_POOL_STATISTICS

Added filter [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)] for table

WRH$_ROWCACHE_SUMMARY_BL

Added filter [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 = 0)] for table WRH$_ROWCACHE_SUMMARY

Added filter [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)] for table WRH$_SGA

Added filter [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)] for table WRH$_SGASTAT_BL

Added filter [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 = 0)] for table WRH$_SGASTAT

Added filter [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)] for table WRH$_PGASTAT

Added filter [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)] for table WRH$_PROCESS_MEMORY_SUMMARY

Added filter [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)] for table WRH$_RESOURCE_LIMIT

Added filter [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)] for table WRH$_SHARED_POOL_ADVICE

Added filter [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)] for table WRH$_SQL_WORKAREA_HISTOGRAM

Added filter [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)] for table WRH$_PGA_TARGET_ADVICE

Added filter [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)] for table WRH$_INSTANCE_RECOVERY

Added filter [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)] for table WRH$_SYSSTAT_BL

Added filter [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 = 0)] for table WRH$_SYSSTAT

Added filter [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)] for table WRH$_PARAMETER_BL

Added filter [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 = 0)] for table WRH$_PARAMETER

Added filter [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)] for table WRH$_UNDOSTAT

Added filter [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)] for table WRH$_SEG_STAT_BL

Added filter [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 = 0)] for table WRH$_SEG_STAT

Added 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0 AND BL_MOVED = 1)] for table WRH$_DLM_MISC_BL

Added filter [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 = 0)] for table WRH$_DLM_MISC

Added 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0 AND BL_MOVED = 1)] for table WRH$_SERVICE_STAT_BL

Added filter [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 = 0)] for table WRH$_SERVICE_STAT

Added filter [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)] for table WRH$_SYSMETRIC_HISTORY

Added filter [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)] for table WRH$_FILEMETRIC_HISTORY

Added filter [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)] for table WRH$_WAITCLASSMETRIC_HISTORY

Added filter [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)] for table

WRH$_TABLESPACE_STAT_BL

Added filter [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 = 0)] for table WRH$_TABLESPACE_STAT

Added filter [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)] for table WRH$_LOG

Added filter [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)] for table WRH$_MTTR_TARGET_ADVICE

Added filter [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)] for table WRH$_TABLESPACE_SPACE_USAGE

Added 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0)] for table WRH$_SYSMETRIC_SUMMARY

Added 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0)] for table WRH$_JAVA_POOL_ADVICE

Added filter [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)] for table WRH$_THREAD

Added filter [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)] for table WRH$_SESSMETRIC_HISTORY

Added filter [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)] for table WRH$_OSSTAT_BL

Added filter [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 = 0)] for table WRH$_OSSTAT

Added 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0 AND BL_MOVED = 1)] for table WRH$_SYS_TIME_MODEL_BL

Added filter [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 = 0)] for table WRH$_SYS_TIME_MODEL

Added 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 = 3990839260

AND SNAP_ID >= 59940 AND SNAP_ID <= 59945 AND STATUS   = 0 AND BL_MOVED = 1)] for table

WRH$_SERVICE_WAIT_CLASS_BL

Added filter [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 = 0)] for table

WRH$_SERVICE_WAIT_CLASS

Added filter [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)] for table WRH$_CR_BLOCK_SERVER

Added filter [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)] for table WRH$_CURRENT_BLOCK_SERVER

Added filter [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)] for table

WRH$_INST_CACHE_TRANSFER_BL

Added filter [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 = 0)] for table

WRH$_INST_CACHE_TRANSFER

Added filter [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)] for table WRH$_STREAMS_POOL_ADVICE

Added filter [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)] for table WRH$_COMP_IOSTAT

Added filter [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)] for table WRH$_SGA_TARGET_ADVICE

Added filter [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)] for table WRH$_SESS_TIME_STATS

Added filter [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)] for table WRH$_STREAMS_CAPTURE

Added filter [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)] for table WRH$_STREAMS_APPLY_SUM

Added filter [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)] for table WRH$_BUFFERED_QUEUES

Added filter [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)] for table WRH$_BUFFERED_SUBSCRIBERS

Added filter [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)] for table WRH$_RULE_SET

Added filter [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)] for table

WRH$_ACTIVE_SESSION_HISTORY_BL

Added filter [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 = 0)] for table

WRH$_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".
                        

                            

                                
< 上一篇
ORACLE PL/SQL 实例精解之第一章 PL/SQL概念
                            
                            

                                 
下一篇 >
大型网站应用中MySQL的架构演变史