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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2143037/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2143037/