Home » RDBMS Server » Performance Tuning » Materialized View issue (Solaris, Oracle
Materialized View issue [message #297288] Thu, 31 January 2008 01:00 Go to next message
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
In our database if I run SQL Access Advisor it is recommended to make 160 Materialized View for 300 tables. If I create materialized view will it improve the database performance. And for Materialized View refresh there are some tables that need to refresh immediately. So will immediate refresh dramatically decrease database performance?

What I can do to increase database performance?
Re: Materialized View issue [message #297310 is a reply to message #297288] Thu, 31 January 2008 01:41 Go to previous message
Michel Cadot
Messages: 63931
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't know, ignore the recommendations.

Previous Topic: Only Select Query Running . Concurrency Problem
Next Topic: Newbie, help with ADDM finding
Goto Forum:

Current Time: Thu Oct 27 06:34:20 CDT 2016

Total time taken to generate the page: 0.16531 seconds