...
| No Format |
|---|
Prompt Specify owner for the tables that you want to replicate Prompt Specify table_name(s) for the tables that you want to replicate. % for all. column owner format A45 set linesize 200 set pagesize 5000 spool unsupported_LOB.txt select owner, table_name, column_name from dba_lobs wherewhere owner not in ( 'XDB','SYS','SYSTEM','SYSMAN','WMSYS','OLAPSYS','MDSYS','APEX_030200','FLOWS_FILES', 'EXFSYS','APPQOSSYS','CTXSYS','ORDDATA','OUTLN','DBSNMP','ORDSYS','DBVREP') and encrypt not in ('NO','NONE') or compression not in ('NO','NONE') or deduplication not in ('NO','NONE') order by owner); spool off |
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