SQL> exec DBMS_SWRF_INTERNAL.MOVE_TO_AWR(SCHNAME => 'AWR_STAGE');
BEGIN DBMS_SWRF_INTERNAL.MOVE_TO_AWR(SCHNAME => 'AWR_STAGE'); END;
*
ERROR at line 1:
ORA-20105: unable to move AWR data to SYS
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 1811
ORA-20107: not allowed to move AWR data for local dbid
ORA-06512: at line 1
@?/rdbms/admin/awrextr.sql
@?/rdbms/admin/awrload.sql
@?/rdbms/admin/awrrpti
remove
DBID
~~~~~~~~~~~~~~~~~~~~~
select min(snap_id),max(snap_id) from
DBA_HIST_SNAPSHOT where dbid= 1648368781 ;
exec
dbms_workload_repository.drop_snapshot_range (-
low_snap_id=> 8583
-
,high_snap_id=> 8587 -
,DBID=> 1648368781 );
delete
DBA_HIST_DATABASE_INSTANCE where dbid=1648368781;
set pages
0
select 'delete '||TABLE_NAME||' where dbid=1648368781;' sql from dba_tables
where table_name like 'WRH$_%';
////////////////////////////////////////////////////////////////////////////////////
SQL>
@?/rdbms/admin/awrload.sql
...............................
Job
"SYS"."SYS_IMPORT_FULL_01" successfully completed at
10:23:36
begin
*
ERROR at line 1:
ORA-20105: unable to move AWR data
to SYS
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 1860 <-- 10.2.0.5 [
10.2.0.3 data ]
ORA-20107: not allowed to move AWR data for local
dbid
ORA-06512: at line 4
... Dropping AWR_STAGE user
End
of AWR Load
SQL>
SQL>
@?/rdbms/admin/awrload.sql
...............................
Job
"SYS"."SYS_IMPORT_FULL_01" successfully completed at
11:23:36
begin
*
ERROR at line 1:
ORA-20105: unable to move AWR data
to SYS
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 1760 <-- 10.2.0.3 [
10.2.0.3 data ]
ORA-20107: not allowed to move AWR data for local
dbid
ORA-06512: at line
3
////////////////////////////////////////////////////////////////////////////////////
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1677721600 bytes
Fixed Size 2084424 bytes
Variable Size 603980216 bytes
Database Buffers 1056964608 bytes
Redo Buffers 14692352 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ydcrh08 utility]$ nid TARGET=system/maneger.pdhptlt10g
DBNEWID: Release 10.2.0.4.0 - Production on Wed Dec 15 16:59:07 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to database PTLT10G (DBID=3258538501)
Connected to server version 10.2.0
Control Files in database:
/db/pdhptlt10g/oradata/cntl01.ctl
/db/pdhptlt10g/oradata/cntl02.ctl
Change database ID of database PTLT10G? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 3258538501 to 3358194351
Control File /db/pdhptlt10g/oradata/cntl01.ctl - modified
Control File /db/pdhptlt10g/oradata/cntl02.ctl - modified
Datafile /db/pdhptlt10g/oradata/system_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/undorbs_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/sysaux_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/AUDIT_TRAIL_D01_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/AUDIT_TRAIL_D01_f02.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/AUDIT_TRAIL_X01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/CORE_OPERATION_D01_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/CORE_OPERATION_D01_f02.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/CORE_OPERATION_X01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/DATA_INTERCHANGE_D01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/DATA_INTERCHANGE_X01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/DISPLACEMENT_CTRL_D01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/DISPLACEMENT_CTRL_X01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/GDR_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/GDR_f02.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/JMS01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/LOB01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/OMS01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/PCC_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/SHIPS_PLANNING_D01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/SHIPS_PLANNING_X01_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/SUPPORT_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/TOPS_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/guider_lob01_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/guider_d01_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/guider_x01_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_L_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_L_f02.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_L_f03.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_L_V_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_M_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_S_f01 - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_XL_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP1_XL_f02.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP2_XL_f01.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/TSP2_XL_f02.dbf - dbid changed
Datafile /db/pdhptlt10g/oradata/temp_f01.dbf - dbid changed
Control File /db/pdhptlt10g/oradata/cntl01.ctl - dbid changed
Control File /db/pdhptlt10g/oradata/cntl02.ctl - dbid changed
Instance shut down
Database ID for database PTLT10G changed to 3358194351.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.
[oracle@ydcrh08 utility]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 15 17:01:08 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1677721600 bytes
Fixed Size 2084424 bytes
Variable Size 603980216 bytes
Database Buffers 1056964608 bytes
Redo Buffers 14692352 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
SQL> select dbid from v$database;
DBID
----------
3358194351
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_10.2_lnx_push/oracle/md/admin
DATA_FILE_DIR /oracle/product/10.2/demo/schema/sales_history/
DATA_PUMP_DIR /oracle/product/10.2/rdbms/log/
LOG_FILE_DIR
/oracle/product/10.2/demo/schema/log/
MEDIA_DIR /oracle/product/10.2/demo/schema/product_media/
SUBDIR
/oracle/product/10.2/demo/schema/order_entry//200
2/Sep
WORK_DIR
/ade/aime_10.2_lnx_push/oracle/work
XMLDIR
/oracle/product/10.2/demo/schema/order_entry/
Choose a Directory Name
from the list above (case-sensitive).
Enter value for directory_name:
DATA_PUMP_DIR
Using the dump directory: DATA_PUMP_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_36675_36678
Loading from the file name:
awrdat_36675_36678.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 <return> 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 *
TEMR
PERMANENT
USERS PERMANENT
XEMR
PERMANENT
Pressing <return> will result in the recommended
default
tablespace (identified by *) being used.
Enter value for
default_tablespace:
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 <return> will result in the database's default
temporary
tablespace (identified by *) being used.
Enter value for
temporary_tablespace:
Using tablespace TEMP as the temporary tablespace
for AWR_STAGE
... Creating AWR_STAGE user
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the
following
| directory/file:
| /oracle/product/10.2/rdbms/log/
|
awrdat_36675_36678.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:
| /oracle/product/10.2/rdbms/log/
|
awrdat_36675_36678.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" 2.104 MB 6590 rows
. .
imported "AWR_STAGE"."WRH$_SYSMETRIC_SUMMARY" 47.35 KB 540 rows
.
. imported "AWR_STAGE"."WRH$_SQLTEXT" 544.3 KB 379
rows
. . imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36686" 16.37
KB 0 rows
. . imported "AWR_STAGE"."WRH$_ENQUEUE_STAT"
21.94 KB 268 rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36686" 9.476 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36614" 9.476 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36638" 9.476 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36662" 89.06 KB 1552
rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36720" 9.476 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36744" 9.476 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36768" 9.476 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1166681123_36686" 23.03 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1166681123_36686" 6.75 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1166681123_36686" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1166681123_36614" 23.03 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1166681123_36638" 23.03 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1166681123_36662" 71.66 KB 189
rows
. . imported
"AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1166681123_36720" 23.03 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1166681123_36744" 23.03 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SQLSTAT":"WRH$_SQLSTA_1166681123_36768" 23.03 KB 0
rows
. . imported "AWR_STAGE"."WRH$_BG_EVENT_SUMMARY" 11.02 KB
112 rows
. . imported
"AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1166681123_36614" 6.75 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1166681123_36638" 6.75 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1166681123_36662" 50.56 KB 1056
rows
. . imported
"AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1166681123_36720" 6.75 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1166681123_36744" 6.75 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_PARAMETER":"WRH$_PARAME_1166681123_36768" 6.75 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1166681123_36686" 16.61 KB 0
rows
. . imported "AWR_STAGE"."WRH$_SHARED_POOL_ADVICE" 11.92
KB 64 rows
. . imported
"AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1166681123_36614" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1166681123_36638" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1166681123_36662" 48.96 KB 1484
rows
. . imported
"AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1166681123_36720" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1166681123_36744" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSSTAT":"WRH$_SYSSTA_1166681123_36768" 6.125 KB 0
rows
. . imported "AWR_STAGE"."WRH$_PGASTAT" 8.976
KB 60 rows
. . imported
"AWR_STAGE"."WRH$_PGA_TARGET_ADVICE" 10.36 KB 56 rows
. .
imported "AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1166681123_36614" 16.61
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1166681123_36638" 16.61 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1166681123_36662" 45.26 KB 260
rows
. . imported
"AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1166681123_36720" 16.61 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1166681123_36744" 16.61 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SEG_STAT":"WRH$_SEG_ST_1166681123_36768" 16.61 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36662" 71.57
KB 294 rows
. . imported
"AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1166681123_36686" 9.187 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1166681123_36686" 7.078
KB 0 rows
. . imported "AWR_STAGE"."WRH$_LIBRARYCACHE"
11.64 KB 44 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1166681123_36686" 6.445 KB 0
rows
. . imported "AWR_STAGE"."WRH$_SQL_BIND_METADATA" 120.7
KB 1851 rows
. . imported "AWR_STAGE"."WRH$_SQL_WORKAREA_HISTOGRAM"
8.539 KB 28 rows
. . imported
"AWR_STAGE"."WRH$_UNDOSTAT" 14.68 KB 24 rows
. .
imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36614" 16.37
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36638" 16.37
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36720" 16.37
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36744" 16.37
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36768" 16.37
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1166681123_36686" 8.625
KB 0 rows
. . imported "AWR_STAGE"."WRH$_EVENT_NAME"
68.24 KB 878 rows
. . imported
"AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1166681123_36614" 9.187 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1166681123_36638" 9.187 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1166681123_36662" 25.40 KB 236
rows
. . imported
"AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1166681123_36720" 9.187 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1166681123_36744" 9.187 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_FILESTATXS":"WRH$_FILEST_1166681123_36768" 9.187 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1166681123_36614" 7.078
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1166681123_36638" 7.078
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1166681123_36662" 20.38
KB 229 rows
. . imported
"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1166681123_36720" 7.078
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1166681123_36744" 7.078
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__1166681123_36768" 7.078
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_LOG" 9.539 KB 20 rows
. .
imported "AWR_STAGE"."WRH$_PARAMETER_NAME" 62.57 KB 1441 rows
.
. imported "AWR_STAGE"."WRH$_PROCESS_MEMORY_SUMMARY" 9.132 KB 16
rows
. . imported "AWR_STAGE"."WRH$_RESOURCE_LIMIT" 8.039
KB 16 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1166681123_36614" 9.507
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1166681123_36638" 9.507
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1166681123_36662" 20.83 KB
184 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1166681123_36686" 9.507
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1166681123_36720" 9.507
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1166681123_36744" 9.507
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_1166681123_36768" 9.507
KB 0 rows
. . imported "AWR_STAGE"."WRH$_SEG_STAT_OBJ"
70.26 KB 612 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1166681123_36614" 6.445 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1166681123_36638" 6.445 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1166681123_36662" 18.66 KB 336
rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1166681123_36720" 6.445 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1166681123_36744" 6.445 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_STAT":"WRH$_SERVIC_1166681123_36768" 6.445 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1166681123_36686" 7.070
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SGA_TARGET_ADVICE" 7.937 KB 32 rows
. .
imported "AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36614" 6.757
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36638" 6.757 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36662" 17.58 KB 288
rows
. . imported
"AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36686" 6.757 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36720" 6.757 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36744" 6.757 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36768" 6.757 KB 0
rows
. . imported "AWR_STAGE"."WRH$_TABLESPACE_SPACE_USAGE" 8.453
KB 32 rows
. . imported "AWR_STAGE"."WRH$_BUFFER_POOL_STATISTICS"
12.17 KB 4 rows
. . imported
"AWR_STAGE"."WRH$_DATAFILE" 11.41 KB 59 rows
. .
imported
"AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1166681123_36614" 8.625
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1166681123_36638" 8.625
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1166681123_36662" 13.96
KB 80 rows
. . imported
"AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1166681123_36720" 8.625
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1166681123_36744" 8.625
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_DB_CACHE_ADVICE":"WRH$_DB_CAC_1166681123_36768" 8.625
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_INSTANCE_RECOVERY" 11.54 KB 4 rows
. .
imported "AWR_STAGE"."WRH$_JAVA_POOL_ADVICE" 8.75 KB 8 rows
.
. imported "AWR_STAGE"."WRH$_LATCH_NAME" 22.59 KB 390
rows
. . imported "AWR_STAGE"."WRH$_METRIC_NAME" 24.89 KB
212 rows
. . imported "AWR_STAGE"."WRH$_OPTIMIZER_ENV" 7.093
KB 8 rows
. . imported
"AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1166681123_36614" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1166681123_36638" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1166681123_36662" 7.289 KB 44
rows
. . imported
"AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1166681123_36686" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1166681123_36720" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1166681123_36744" 6.125 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_OSSTAT":"WRH$_OSSTAT_1166681123_36768" 6.125 KB 0
rows
. . imported "AWR_STAGE"."WRH$_OSSTAT_NAME" 5.812
KB 11 rows
. . imported "AWR_STAGE"."WRH$_SERVICE_NAME"
5.945 KB 3 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1166681123_36614" 7.070
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1166681123_36638" 7.070
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1166681123_36662" 11.92
KB 96 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1166681123_36720" 7.070
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1166681123_36744" 7.070
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_1166681123_36768" 7.070
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SGA" 6.734 KB 16 rows
. .
imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36614" 6.429
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36638" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36662" 10.51 KB 88
rows
. . imported
"AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36686" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36720" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36744" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36768" 6.429 KB 0
rows
. . imported "AWR_STAGE"."WRH$_SQL_SUMMARY" 6.914 KB
4 rows
. . imported "AWR_STAGE"."WRH$_STAT_NAME" 22.57 KB
389 rows
. . imported
"AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1166681123_36614" 6.132 KB
0 rows
. . imported
"AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1166681123_36638" 6.132 KB
0 rows
. . imported
"AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1166681123_36662" 8.492
KB 76 rows
. . imported
"AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1166681123_36686" 6.132 KB
0 rows
. . imported
"AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1166681123_36720" 6.132 KB
0 rows
. . imported
"AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1166681123_36744" 6.132 KB
0 rows
. . imported
"AWR_STAGE"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_1166681123_36768" 6.132 KB
0 rows
. . imported
"AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1166681123_36614" 7.679
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1166681123_36638" 7.679
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1166681123_36662" 9.390
KB 28 rows
. . imported
"AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1166681123_36686" 7.679
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1166681123_36720" 7.679
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1166681123_36744" 7.679
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_1166681123_36768" 7.679
KB 0 rows
. . imported "AWR_STAGE"."WRH$_TEMPFILE"
7.109 KB 1 rows
. . imported
"AWR_STAGE"."WRH$_TEMPSTATXS" 9.406 KB 4 rows
. .
imported "AWR_STAGE"."WRH$_THREAD" 7.539 KB 4 rows
.
. imported "AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1166681123_36614" 6.429
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1166681123_36638" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1166681123_36662" 9.070 KB 72
rows
. . imported
"AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1166681123_36686" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1166681123_36720" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1166681123_36744" 6.429 KB 0
rows
. . imported
"AWR_STAGE"."WRH$_WAITSTAT":"WRH$_WAITST_1166681123_36768" 6.429 KB 0
rows
. . imported "AWR_STAGE"."WRM$_DATABASE_INSTANCE" 7.476 KB
1 rows
. . imported "AWR_STAGE"."WRM$_SNAPSHOT" 8.679
KB 4 rows
. . imported "AWR_STAGE"."WRM$_WR_CONTROL"
10.14 KB 1 rows
. . imported
"AWR_STAGE"."WRH$_ACTIVE_SESSION_HISTORY":"WRH$_ACTIVE_1166681123_36792" 0
KB 0 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$_CR_BLOCK_SERVER" 0
KB 0 rows
. . imported "AWR_STAGE"."WRH$_CURRENT_BLOCK_SERVER"
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":"WRH$_DB_CAC_1166681123_36792" 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":"WRH$_DLM_MI_1166681123_0" 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":"WRH$_FILEST_1166681123_36792" 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":"WRH$_INST_C_1166681123_0" 0
KB 0 rows
. . imported "AWR_STAGE"."WRH$_INST_CACHE_TRANSFER_BL"
0 KB 0 rows
. . imported
"AWR_STAGE"."WRH$_LATCH":"WRH$_LATCH_1166681123_36792" 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__1166681123_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":"WRH$_LATCH__1166681123_36792" 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__1166681123_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_1166681123_36792" 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":"WRH$_PARAME_1166681123_36792" 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":"WRH$_ROWCAC_1166681123_36792" 0
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_ROWCACHE_SUMMARY_BL" 0 KB 0 rows
. .
imported "AWR_STAGE"."WRH$_RULE_SET" 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":"WRH$_SEG_ST_1166681123_36792" 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":"WRH$_SERVIC_1166681123_36792" 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":"WRH$_SERVIC_1166681123_36792" 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$_SESS_TIME_STATS" 0 KB 0
rows
. . imported "AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN" 0
KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SGASTAT":"WRH$_SGASTA_1166681123_36792" 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":"WRH$_SQLSTA_1166681123_36792" 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$_STREAMS_POOL_ADVICE" 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":"WRH$_SYSSTA_1166681123_36792" 0
KB 0 rows
. . imported "AWR_STAGE"."WRH$_SYSSTAT_BL"
0 KB 0 rows
. . imported
"AWR_STAGE"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_1166681123_36792" 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":"WRH$_SYS_TI_1166681123_36792" 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":"WRH$_TABLES_1166681123_36792" 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":"WRH$_WAITST_1166681123_36792" 0 KB 0
rows
. . imported "AWR_STAGE"."WRH$_WAITSTAT_BL" 0 KB
0 rows
. . imported "AWR_STAGE"."WRM$_SNAP_ERROR" 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 23:57:41
Register the DBID: 1166681123
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
SQL>
@?/rdbms/admin/awrrpti
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
------------ -------- ------------
------------ ------------
1166681123 1 ORCL ORCL
localhost
* 1302312608 1 ORCL ORCL
localhost
Enter value for dbid: 1166681123
Using 1166681123 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 <return> without
specifying a number lists all
completed snapshots.
Enter value for num_days:
Listing all
Completed
Snapshots
Snap
Instance
DB Name Snap Id Snap Started Level
------------ ------------
--------- ------------------ -----
ORCL ORCL 36675 27 Aug
2010 14:00 1
36676 27 Aug 2010
15:00 1
36677 27 Aug 2010
16:00 1
36678 27 Aug 2010
17:00 1
36780 31 Aug 2010
23:00 1
36781 01 Sep 2010 00:00 1
