IT技术博客大学习 共学习 共进步
全部 移动开发 后端 数据库 AI 算法 安全 DevOps 前端 设计 开发者

AWR 与 Statspack 数据的导出与迁移

Oracle Life 2010-08-01 19:53:23 累计浏览 2,737 次
本机暂存
LEMETRIC_HISTORY"                 0 KB       0 rows

    . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILESTATXS_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_FILESTATXS":"WRH$_FILEST_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_FILESTATXS_BL"                      0 KB       0 rows

    . . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_CACHE_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_INST_CACHE_TRANSFER":"WRH$_INST_C_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_INST_CACHE_TRANSFER_BL"             0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH":"WRH$_LATCH_MXDB_MXSN"       0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_BL"                           0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH_CHILD_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_CHILDREN":"WRH$_LATCH__3368702614_0"      0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_CHILDREN_BL"                  0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH_MISSE_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY":"WRH$_LATCH__3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_MISSES_SUMMARY_BL"            0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH_PAREN_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_PARENT":"WRH$_LATCH__3368702614_0"      0 KB       0 rows

    . . exported "SYS"."WRH$_LATCH_PARENT_BL"                    0 KB       0 rows

    . . exported "SYS"."WRH$_MTTR_TARGET_ADVICE"                 0 KB       0 rows

    . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_OSSTAT":"WRH$_OSSTAT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_OSSTAT_BL"                          0 KB       0 rows

    . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAMETER_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_PARAMETER":"WRH$_PARAME_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_PARAMETER_BL"                       0 KB       0 rows

    . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCACHE_SU_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_ROWCACHE_SUMMARY":"WRH$_ROWCAC_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_ROWCACHE_SUMMARY_BL"                0 KB       0 rows

    . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_STAT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SEG_STAT":"WRH$_SEG_ST_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SEG_STAT_BL"                        0 KB       0 rows

    . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVICE_STAT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SERVICE_STAT":"WRH$_SERVIC_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SERVICE_STAT_BL"                    0 KB       0 rows

    . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVICE_WAIT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS":"WRH$_SERVIC_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SERVICE_WAIT_CLASS_BL"              0 KB       0 rows

    . . exported "SYS"."WRH$_SESSMETRIC_HISTORY"                 0 KB       0 rows

    . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTAT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SGASTAT":"WRH$_SGASTA_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SGASTAT_BL"                         0 KB       0 rows

    . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTAT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SQLSTAT":"WRH$_SQLSTA_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SQLSTAT_BL"                         0 KB       0 rows

    . . exported "SYS"."WRH$_STREAMS_APPLY_SUM"                  0 KB       0 rows

    . . exported "SYS"."WRH$_STREAMS_CAPTURE"                    0 KB       0 rows

    . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTAT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SYSSTAT":"WRH$_SYSSTA_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SYSSTAT_BL"                         0 KB       0 rows

    . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SYSTEM_EVENT":"WRH$_SYSTEM_EVEN_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SYSTEM_EVENT_BL"                    0 KB       0 rows

    . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TIME_MO_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_SYS_TIME_MODEL":"WRH$_SYS_TI_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_SYS_TIME_MODEL_BL"                  0 KB       0 rows

    . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLESPACE_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_TABLESPACE_STAT":"WRH$_TABLES_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_TABLESPACE_STAT_BL"                 0 KB       0 rows

    . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITSTAT_MXDB_MXSN"      0 KB       0 rows

    . . exported "SYS"."WRH$_WAITSTAT":"WRH$_WAITST_3368702614_22508"      0 KB       0 rows

    . . exported "SYS"."WRH$_WAITSTAT_BL"                        0 KB       0 rows

    . . exported "SYS"."WRM$_SNAP_ERROR"                         0 KB       0 rows

    . . exported "SYS"."WRR$_CAPTURES"                           0 KB       0 rows

    . . exported "SYS"."WRR$_CAPTURE_STATS"                      0 KB       0 rows

    . . exported "SYS"."WRR$_FILTERS"                            0 KB       0 rows

    Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

    ******************************************************************************

    Dump file set for SYS.SYS_EXPORT_TABLE_01 is:

    /opt/oracle/backup/awrdat_22338_22505.dmp

    Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 23:41:54

     非常简单易用,记录一下供参考!原图已失效

同分类推荐文章

  1. 使用deepseek进行Oracle恢复,引起重大故障 (2026-06-22 10:56:00)
  2. 接手一个只差临门一脚的数据库恢复 (2026-06-18 00:13:09)
  3. 我做了一个 AI 版的 StarRocks 升级风险扫描工具,直接帮我定位到一个风险 (2026-06-15 01:00:00)

查看更多 数据库 文章 →

建议继续学习

  1. Oracle MTS模式下 进程地址与会话信息 (累计阅读 14,407)
  2. 那些在11gR2中可能惹祸的新特性,一张列表帮助你摆脱升级11gR2带来的烦恼 (累计阅读 6,879)
  3. 性能测试工具sysbench简介 (累计阅读 6,026)
  4. 大于2GB的Listener.log和运行超过198天的主机上的Oracle实例 (累计阅读 5,862)
  5. 仅仅只备份是不够的 (累计阅读 5,824)
  6. Oracle Database 12c 新特性 - Native Top N 查询 (累计阅读 5,750)
  7. ORACLE最大可以存储多少数据量 (累计阅读 5,728)
  8. Oracle DBA的学习进阶成长树-从初出茅庐到高瞻远瞩 (累计阅读 5,602)
  9. 老托的Oracle 数据库Patch概念性小常识 (累计阅读 5,548)
  10. 查看oracle数据库用户下的所有空表 (累计阅读 5,503)