Hi >On 05/29/2006 05:52:26 AM, Sachin Sethi wrote: >> HI >> >> IT IS BENIFICIAL TO HAVE MATEREIALIZED VIES IN OLTP SYSTEM >> PLEASE HELP ME > >It is definitely beneficial to release the Caps Lock key. You've gotta ask >yourself one question: what do you want that MV for? Can you tolerate data >being refreshed at discreet intervals or do you really need them in real time? >As one great DBA has put it, you can't always get what you want but you can try >sometimes. > >-- >Mladen Gogala I agree with Mladen. That said, I successfully used MV in OLTP system twice for performance reasons. The first time with a fast refresh every minute (or something like that), the second time with a fast refresh on commit. HTH Chris -- //www.freelists.org/webpage/oracle-l