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