mystat脚本以及使用
---------------
包含两个脚本
mystat.sql和mystat2.sql
用于展示完成某操作之前和之后的某些oracle“统计结果”的变化情况
mystat.sql只能获得统计结果的开始值
mystat2.sql用于报告统计结果的变化情况
mystat.sql和mystat2.sql
用于展示完成某操作之前和之后的某些oracle“统计结果”的变化情况
mystat.sql只能获得统计结果的开始值
mystat2.sql用于报告统计结果的变化情况
内容如下:
--mystat.sql
set echo off
set verify off
column value new_val V
define S="&1"
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')||'%'
/
set echo on
set verify off
column value new_val V
define S="&1"
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')||'%'
/
set echo on
--mystat2.sql
set echo off
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')||'%'
/
set echo on
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')||'%'
/
set echo on
----------------
使用
--查看当前redo size情况
NAME VALUE
---------------------------------------------------------------- ----------
redo size 273085624
---------------------------------------------------------------- ----------
redo size 273085624
--更新数据
sys@DB10> update btest set id=id+1;
sys@DB10> update btest set id=id+1;
已更新1000000行。
sys@DB10> commit;
提交完成。
NAME V DIFF
---------------------------------------------------------------- ---------- ----------------
redo size 566774376 293,688,752
---------------------------------------------------------------- ---------- ----------------
redo size 566774376 293,688,752
NAME VALUE
---------------------------------------------------------------- ----------
redo size 566774376
---------------------------------------------------------------- ----------
redo size 566774376
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13177610/viewspace-694941/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13177610/viewspace-694941/