This discussion is archived
1 Reply Latest reply: Feb 14, 2013 7:54 AM by UweHesse RSS

Flash Cache is useful for Materalized Views?

User505978 - Oracle Newbie
Currently Being Moderated
Hi,

We have 2 different database in seperate servers. Both database is Quarted Exadata.

We have some customer tables on core banking database and we created MVs on the oter database for these table via db link.

Sessions are coming from clients to the database which has MVs and making complex query by using MVs.


Do you think placing thse MVs to the flash cache can give us some benefit?
  • 1. Re: Flash Cache is useful for Materalized Views?
    UweHesse Expert
    Currently Being Moderated
    1) The access over the DB link may take more time than the access on the remote DB to the MV there, so the effect of that flash caching may not be so noticeable.
    2) It is likely that the container tables of the MVs are flash cached automatically by the cells, if that seems sensible.
    3) You can very easy check out if ALTER TABLE MV-Container-Table-Name STORAGE (CELL_FLASH_CACHE KEEP) makes a difference

    Kind regards
    Uwe Hesse

    "Don't believe it, test it!"
    http://uhesse.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points