Login  Register

Monitor MV

Posted by Roshan on Apr 25, 2021; 3:11pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Monitor-MV-tp9668.html

Hello Erman,

is there a way we can monitor the materialized view resource consumption running on DB?

Should I run trance file on DB?
SQL> alter session set events '10046 trace name context forever, level 12';

Regards,

Roshan