Home » SQL & PL/SQL » SQL & PL/SQL » How To Measure Time To Build a Materialized View (Oracle Database 12c Enterprise Edition Release 12.2.0.1.0)
How To Measure Time To Build a Materialized View [message #677734] Wed, 09 October 2019 11:53 Go to next message
wtolentino
Messages: 284
Registered: March 2005
Senior Member
how do you measure the time it will take for a materialized view to be build/created. the query to build/create the materialize view when run takes about seconds to complete. but creating the materialized view takes longer. we know that it will take longer to create/build the materialize view than just running it's query. we would like to know on how to get an estimate of how long it will take to build/create a materialized view.

thank you.

[Updated on: Wed, 09 October 2019 11:58]

Report message to a moderator

Re: How To Measure Time To Build a Materialized View [message #677735 is a reply to message #677734] Wed, 09 October 2019 12:49 Go to previous messageGo to next message
Bill B
Messages: 1917
Registered: December 2004
Senior Member
There is no measure of how long it will take. It is a measure of how the query is written to build the MVIEW. As a side note, if at all possible make your MVIEW a fast refreshed MVIEW. You will be glad that you did.
Re: How To Measure Time To Build a Materialized View [message #677736 is a reply to message #677734] Wed, 09 October 2019 12:51 Go to previous message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The answers will likely be the same ones than in your previous topic, but maybe you didn't see the answers as you didn't feedback.

Previous Topic: How to get response from xml in oracle
Next Topic: Error message: ORA-08103: object no longer exists.
Goto Forum:
  


Current Time: Fri Dec 06 09:51:30 CST 2019