...
Redo Volume Trending Report :
...
set
...
linesize
...
200
...
set
...
echo
...
off
spool redo_estimate.txt
select name,dbid, database_role, log_Mode from v$database;
select instance_name from v$instance;
ALTER SESSION SET NLS_DATE_FORMAT
...
=
...
'YYYY
...
MM
...
DD';
...
ttitle left '*****
...
Number
...
of
...
redo
...
files
...
for
...
previous
...
7
...
days
...
by
...
hour
...
*****'
...
skip
...
2
...
btitle
...
off
...
SELECT
...
to_date(first_time)
...
DAY,
...
to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'9999')
...
"00",
...
to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'9999')
...
"01",
...
to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)),'9999')
...
"02",
...
to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)),'9999')
...
"03",
...
to_char(sum(decode(to_char(first_time,'HH24'),'04',1,0)),'9999')
...
"04",
...
to_char(sum(decode(to_char(first_time,'HH24'),'05',1,0)),'9999')
...
"05",
...
to_char(sum(decode(to_char(first_time,'HH24'),'06',1,0)),'9999')
...
"06",
...
to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)),'9999')
...
"07",
...
to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)),'9999')
...
"08",
...
to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)),'9999')
...
"09",
...
to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)),'9999')
...
"10",
...
to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)),'9999')
...
"11",
...
to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)),'9999')
...
"12",
...
to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)),'9999')
...
"13",
...
to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)),'9999')
...
"14",
...
to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)),'9999')
...
"15",
...
to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)),'9999')
...
"16",
...
to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)),'9999')
...
"17",
...
to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)),'9999')
...
"18",
...
to_char(sum(decode(to_char(first_time,'HH24'),'19',1,0)),'9999')
...
"19",
...
to_char(sum(decode(to_char(first_time,'HH24'),'20',1,0)),'9999')
...
"20",
...
to_char(sum(decode(to_char(first_time,'HH24'),'21',1,0)),'9999')
...
"21",
...
to_char(sum(decode(to_char(first_time,'HH24'),'22',1,0)),'9999')
...
"22",
...
to_char(sum(decode(to_char(first_time,'HH24'),'23',1,0)),'9999')
...
"23"
...
from
...
sys.v$log_history
...
where
...
to_date(first_time)
...
>
...
sysdate
...
-8
...
GROUP
...
by
...
to_char(first_time,'YYYY-MON-DD'),
...
to_date(first_time)
...
order
...
by
...
to_date(first_time)
...
/
...
rem
...
Size
...
of
...
logs
...
to
...
help
...
do
...
the
...
math
...
in
...
bytes.
...
ttitle
...
left
...
'*****
...
Size
...
of
...
redo
...
logs.
...
Multiple
...
number
...
of
...
logs
...
per
...
hour
...
by
...
Size
...
of
...
Redo
...
to
...
get
...
volume
...
in
...
Meg/Hr
...
*****'
...
skip
...
2
...
btitle
...
off
...
select
...
group#,members,archived,
...
status,
...
trunc((bytes)/1000000)
...
Size_of_Redo_Megbytes
...
from
...
sys.v$log
...
/
...
spool
...
off
...
exit