Materialized View Estimation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Materialized View Estimation

  1. #1
    Join Date
    Sep 2001
    Location
    UK
    Posts
    45

    Materialized View Estimation

    Hi,

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width