Home » RDBMS Server » Performance Tuning » Materialized View issue (Solaris, Oracle 10.2.0.2)
Materialized View issue [message #297288] Thu, 31 January 2008 01:00 Go to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
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: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't know, ignore the recommendations.

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


Current Time: Fri Dec 09 01:49:32 CST 2016

Total time taken to generate the page: 0.07225 seconds