Home » Server Options » Replication » Materialized view cannot be used in OLTP
Materialized view cannot be used in OLTP [message #28481] Wed, 24 December 2003 02:06 Go to next message
Messages: 10
Registered: July 2001
Junior Member
HI all,

Can anyone please explain , why Oracle recommends materialized view to be used in DSS systems and not
in OLTP kind of system.


Re: Materialized view cannot be used in OLTP [message #28493 is a reply to message #28481] Thu, 25 December 2003 04:14 Go to previous message
Messages: 1089
Registered: May 2002
Senior Member
it depends on how active your OLTP database is and how your MVIEWs are defined.When there are 1000s of transactions against tables and you have defined your MViews to be REFRESH on COMMIT,then it results in a lot of overhead & contention(on the summary tables) , which the OLTP system may not be able to cope up with.

That being said,you can still define materialized views on OLTP systems, when you can REFRESH ON DEMAND or periodically when the load is light.

Previous Topic: Question on refreshing Materialised Views in
Next Topic: Refresing Snapshot and DBlink
Goto Forum:

Current Time: Sat May 25 03:15:16 CDT 2024