计算session的日志生成量
看了tom的书，把如何计算当前session的日志生成量罗列在这里
redostart.sql
----------------
set verify off
column value new_val V
define S="redo size"
set autotrace off
select a.name,b.value
from v$statname a,v$mystat b
where a.statistic#=b.statistic#
and lower(a.name) like '%' || lower('&S')||'%'
/
redoend.sql
------------------
set verify off
select a.name,b.value V,to_char(b.value-&V,'999,999,999,999') diff
from v$statname a,v$mystat b
where a.statistic#=b.statistic#
and lower(a.name) like '%'||lower('&S')||'%'
/
这里在补充一下
如果我要监控其他session的日志生成量呢？
这时我们可以利用v$sessstat来代替v$mystat这个视图
redostart.sql
------------------
set verify off
column value new_val V
define S="&1"
set autotrace off
select a.name,b.value
from v$statname a,v$sesstat b
where a.statistic#=b.statistic#
and lower(a.name) like '%' || lower('redo size')||'%'
and b.sid=&S
/
redoend.sql
-----------------
set verify off
select a.name,b.value V,to_char(b.value-&V,'999,999,999,999') diff
from v$statname a,v$sesstat b
where a.statistic#=b.statistic#
and lower(a.name) like '%'||lower('redo size')||'%'
and b.sid=&S
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12361284/viewspace-153405/ ，如需转载，请注明出处，否则将追究法律责任。
