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

[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

    xxxxxxdg

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

SYS@xxxdg2> @ &r/ver

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

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.至于其他有什么好方法,我就不是很清除了.