Re: Perf advice :)

Posted by ErmanArslansOracleBlog on Dec 18, 2023; 8:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Perf-advice-tp12209p12213.html

Than you Laurel, everything is fine, I hope the same for you.

So your problem is with those Insert statements, right? Insert into RV$... You can't manipulate the access paths of them.. Actually there are good access paths for them, but you can't use those access path due to the changing names of those RV$ tables in every time you refresh your MV.

Good question! Let me check..

But first; , did you try it with out_of_place -> FALSE? Does it give you some extra flexibility , a higher degree of freedom for manipulating the access path of the queries and DMLs running in the background of a MV refresh?

And what is your database 4 digit version?

Again, these are fast comments and questions, I will check your issue more deeply once I have enough time.