Materialized View Estimation
What is the best way of estimating the size for a MV before it's creation
I have to create an MV of a table located on remote database
which will be an exact replica of the master table (all columns)
with a fast refresh.
I have tried using the dbms_olap.est_mview_size pkg
but it does not give me any value
Thnx in advance
With it being an exact replica the only variables are the storage (pctfree / pctused / block size etc) so i don't see how this is difficult at all
Did you said your MV will be an "exact replica" of the master table?
You can be sure your MV is not going to be larger than your base table, probably smaller. How smaller? ... it depends of how much wasted space you have in your base table 'cause of fragmentation.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width