tailieunhanh - Rampant TechPress Oracle Data Warehouse Management PHẦN 3

Tên dịch vụ (thường là giống như SID) MTS_DISPATCHERS - Thiết lập số lượng cơ sở của trạm điều phối MTS_MAX_DISPATCHERS - Thiết lập số lượng tối đa của trạm điều phối không MTS_SERVERS - Thiết lập số lượng tối thiểu của máy chủ MTS_MAX_SERVERS - Bộ | ROBO Books Monograph Data Warehousing and Oracle8i PARALLEL_MIN_SERVERS - Sets the minimum number of parallel servers can never go below this level inspite of exceeding PARALLEL_SERVER_IDLE_TIME PARALLEL_SERVER_IDLE_TIME - If a server is idle this long it is killed PARALLEL_MAX_SERVERS - Maximum number of servers that can be started will shrink back to PARALLEL_MIN_SERVERS. Use of MTS MTS or multi-threaded server is really intended for systems where there are a large number of users over 150 and a limited amount of memory. The multithreaded serve is set up using the following initialization parameters SHARED_POOL_SIZE - needs to be increased to allow for UGA MTS_LISTENER_ADDRESS - Sets the address for the listener MTS_SERVICE - Names the service usually the same as SID MTS_DISPATCHERS - Sets the base number of dispatchers MTS_MAX_DISPATCHERS - Sets the maximum number of dispatchers MTS_SERVERS - Sets the minimum number of servers MTS_MAX_SERVERS - Sets the maximum number of servers If you have a low number of users and no memory problems using MTS can reduce your performance. MTS is most useful in an OLTP environment where a large number of users may sign on to the database but only a few are actually doing any work concurrently. Oracle8 Features Objectives The objectives for this section on Oracle8 features are to 1. Identify to the student the Oracle8 data warehouse related features 2. Discuss the use of partitioned tables and indexes 3. Discuss the expanded parallel abilities of Oracle8 4. Discuss the star query structure aware capabilities of the optimizer Page 19 COPYRIGHT 2003 Rampant TechPress. All Rights Reserved. ROBO Books Monograph Data Warehousing and Oracle8i 5. Discuss new indexing options 6. Discuss new Oracle8 internals options 7. Discuss RMAN and its benefits in Oracle8 for data warehousing Partitioned Tables and Indexes In Oracle7 we discussed the use of partitioned views. Partitioned views had several problems. First each table in a partitioned .