Difference between revisions of "Perf redo volume.sql"

From Robs_Wiki
Jump to: navigation, search
(Created page with "Script: <pre> select trunc(completion_time) rundate ,count(*) logswitch ,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)" from v$archived_log group by trunc(comp...")
 
(No difference)

Latest revision as of 10:22, 15 August 2019

Script:

select trunc(completion_time) rundate
,count(*)  logswitch
,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)"
from v$archived_log
group by trunc(completion_time)
order by 1;

Sample output:

RUNDATE    LOGSWITCH REDO PER DAY (MB)
--------- ---------- -----------------
15-JUN-19          4              1140
16-JUN-19         52             16906
17-JUN-19         72             24464
18-JUN-19         74             25542
19-JUN-19         82             27405
20-JUN-19         76             26852
21-JUN-19        100             34947
22-JUN-19         42             12866
23-JUN-19         38             12009
24-JUN-19         96             33081
25-JUN-19         70             22638
. . .