Performing complete refreshes in the middle of a workday is generally
unacceptable. Therefore, it is the frequency of the refreshes rather than the size of them that
determines which type of materialized view will better serve the users. After all, users are most
concerned about the performance of the system while they are using it; refreshes performed late
at night do not directly affect them. If the tables need to be frequently synchronized, use simple
materialized views with materialized view logs.
As was noted previously in this chapter, you may index the underlying tables that are created
by the materialized view in the local database. Indexing should also help to improve query
performance, at the expense of slowing down the refreshes.
Another means of reducing network traffic, via remote procedure calls, is described in Chapter 8.
That chapter also includes information on tuning SQL and the application design. If the database
was properly structured, tuning the way the application processes data will yield the most significant
performance improvements.
APPENDIX
Installation and
Configuration
635
636 Oracle Database 11g DBA Handbook
nstalling Oracle Database 10g is easy; installing Oracle Database 11g is even
easier. In this appendix, I??™ll give you an overview of what you need to do before
you start the installation process, including the configuration of the operating
system software and server hardware.
Pages:
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937