Home » SQL & PL/SQL » SQL & PL/SQL » Redo log generated in Materalized view (oracle 10g,oracle 11g)
Redo log generated in Materalized view [message #572811] Mon, 17 December 2012 15:59 Go to next message
sachin99
Messages: 7
Registered: December 2012
Junior Member
Hi,

As we know that, MV is genrgerating more redo logs during the FAST refresh. but i need more clarfications on that.

see the below examples:

exec dbms_mview.REFRESH ( LIST => 'mv_test', method=>'F');

PL/SQL procedure successfully completed.

select a.name, b.value
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and a.name = 'redo size';

NAME VALUE
---------------------------------------------------------------- ----------
redo size 147144

see the redo size is 147144 bytes. Immediately, i refreshed in MV view. now there is no update or insert or delete stats happened in source tables. but i do see redo log generation is high for NO DATA refresh.

select a.name, b.value-147144
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and a.name = 'redo size';

NAME VALUE
---------------------------------------------------------------- ----------
redo size 42352

For no rows refresh, it takes 42352 bytes.. why oracle generated redo logs when there is no DML operations happend in spource table.


Please clarify the my questions

Re: Redo log generated in Materalized view [message #572831 is a reply to message #572811] Tue, 18 December 2012 01:10 Go to previous message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because it has some internal work to do like updating the last refresh time.

Regards
Michel
Previous Topic: how to execute dynamic sql in procedure with special characters?
Next Topic: ORA-06502: PL/SQL: numeric or value error
Goto Forum:
  


Current Time: Mon Jul 28 14:21:21 CDT 2014

Total time taken to generate the page: 0.10986 seconds