redo量和undo量的统计
1(会话):set autot on
2(会话):select a.name,b.value
from v$statname a,v$mystat b
where a.STATISTIC# = b.STATISTIC# and a.name = 'redo size';
3:(全局)select name,value from v$systat where name='redo size';
//根据时间查找时间段产生的redo量
select (select value/1024/1024/1024 from v$sysstat where name='redo size')/
(select round(sysdate - ( select startup_time from v$instance)) from dual) REDO_GB_PER_DAY
from dual;
//v$archived_log //估算产生的归档日志
select trunc(COMPLETION_TIME),sum(Mb)/1024 DAY_GB from
(select name,COMPLETION_TIME,BLOCKS*BLOCK_SIZE/1024/1024 Mb from v$archived_log
where COMPLETION_TIME between trunc(sysdate) -2 and trunc(sysdate) -1)
group by trunc(COMPLETION_TIME)
//最近日期日志的生成情况
SELECT TRUNC (completion_time), SUM (mb) / 1024 day_gb
FROM (SELECT NAME, completion_time, blocks * block_size / 1024 / 1024 mb
FROM v$archived_log)
GROUP BY TRUNC (completion_time)
//log file parallel write wait event
//索引
//undo和temp空间
col name for a30
select a.name,b.value
from v$statname a,v$mystat b
where a.STATISTIC# = b.STATISTIC# and a.name = 'redo size';
select (select value/1024/1024/1024 from v$sysstat where name='redo size')/
(select round(sysdate - ( select startup_time from v$instance)) from dual) REDO_GB_PER_DAY
from dual;
1(会话):set autot on
2(会话):select a.name,b.value
from v$statname a,v$mystat b
where a.STATISTIC# = b.STATISTIC# and a.name = 'redo size';
3:(全局)select name,value from v$systat where name='redo size';
//根据时间查找时间段产生的redo量
select (select value/1024/1024/1024 from v$sysstat where name='redo size')/
(select round(sysdate - ( select startup_time from v$instance)) from dual) REDO_GB_PER_DAY
from dual;
//v$archived_log //估算产生的归档日志
select trunc(COMPLETION_TIME),sum(Mb)/1024 DAY_GB from
(select name,COMPLETION_TIME,BLOCKS*BLOCK_SIZE/1024/1024 Mb from v$archived_log
where COMPLETION_TIME between trunc(sysdate) -2 and trunc(sysdate) -1)
group by trunc(COMPLETION_TIME)
//最近日期日志的生成情况
SELECT TRUNC (completion_time), SUM (mb) / 1024 day_gb
FROM (SELECT NAME, completion_time, blocks * block_size / 1024 / 1024 mb
FROM v$archived_log)
GROUP BY TRUNC (completion_time)
//log file parallel write wait event
//索引
//undo和temp空间
col name for a30
select a.name,b.value
from v$statname a,v$mystat b
where a.STATISTIC# = b.STATISTIC# and a.name = 'redo size';
select (select value/1024/1024/1024 from v$sysstat where name='redo size')/
(select round(sysdate - ( select startup_time from v$instance)) from dual) REDO_GB_PER_DAY
from dual;