[20170803]如何查看dg的redo应用率.txt

--//昨天别人问的问题,实际上如果安装配置DGMGRL,在11.2.0.4下变得很简单.直接执行:

1.环境:

SYS@xxxxdg2> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.登录DGMGRL,执行:

DGMGRL> show database   xxxxdg

Database - xxxxdg

  Enterprise Manager Name: xxxx_dg

  Role:                    PHYSICAL STANDBY   Intended State:          APPLY-ON   Transport Lag:           0 seconds (computed 0 seconds ago)   Apply Lag:               0 seconds (computed 0 seconds ago)   Apply Rate:              532.00 KByte/s   Real Time Query:         ON   Instance(s):     xxxxdg Database Status: SUCCESS

--//可以很轻松的知道当前的redo Apply Rate.如果11.2.0.3,使用DGMGRL就无效了.

3.11.2.0.3环境:

SYS@xxxxxx> select * from v$version where rownum<=1; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

DGMGRL> show database xxxxxxdg

Database - xxxxxxdg

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON   Transport Lag:   0 seconds   Apply Lag:       0 seconds   Real Time Query: ON   Instance(s):     xxxxxxdg

Database Status:

SUCCESS

4.10g下有1个视图V$STANDBY_APPLY_SNAPSHOT,可以获得当前的应用率,11g下取消了这个视图定义.

SYS@xxxdg2> @ &r/ver

BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

SYS@xxxdg2> select * from V$STANDBY_APPLY_SNAPSHOT;

SNAPSHOT_TIME            SESSION_ID         THREAD# RESET_TIMESTAMP       SEQUENCE#          BLOCK#     APPLIED_SCN APPLIED_TIME        NEWEST_RESET_TIMESTAMP NEWEST_ARCHIVED_SEQ# NEWEST_TIME             NEWEST_USED NEWEST_SRL_SEQ#       BLOCKSIZE      APPLY_RATE ------------------- --------------- --------------- --------------- --------------- --------------- --------------- ------------------- ---------------------- -------------------- ------------------- --------------- --------------- --------------- --------------- 2017-08-03 15:47:02                               1       628034536           54123           53541     19068156503 2017-08-03 15:46:59              628034536                54122 2017-08-03 15:47:01        27412992           54123             512             122

SYS@xxxdg2> select snapshot_time, thread#, sequence#, applied_scn,apply_rate from V$standby_apply_snapshot;

SNAPSHOT_TIME               THREAD#       SEQUENCE#     APPLIED_SCN      APPLY_RATE ------------------- --------------- --------------- --------------- --------------- 2017-08-03 15:48:02               1           54123     19068170132             122

5.至于其他有什么好方法,我就不是很清除了.