Explain plan for mview refresh in oracle

Explain plan for mview refresh

alter session set tracefile_identifier=ahsan

alter session set events '10046 trace name context forever, level 12';

exec dbms_mview.refresh ('MY_MVIEW_NAME','C');

alter session set events '10046 trace name context off';

then go in /mnt/oracle-dev1/admin/adapp/udump
search the last file with "ahsan" in it

tkprof

It will give you the output of input trace file in a readable format.

Sphere: Related Content