[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/