Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Essbase 9 Implementation Guide- P15:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | Chapter 2 Its better to look at the real screen for yourself through the EAS. When it comes to performance tuning the settings on this screen will be invaluable Caches tab Correctly set caches can make the difference between your business partner wanting to fire you or wanting to adopt you. We will discuss these important settings later on but for now just know that the default settings will be adequate for most moderate sized cubes with moderate sized calculation or reporting needs. One suggestion on caches unless you are using the direct I O data load option which we will discuss in detail later is to never check the Cache memory locking option . The Cache memory locking option locks the maximum amount of memory for each cache whether the database uses it or not. If your system is running that close to maximum capacity you better purchase some more memory in a hurry 55 Download at Boykma.Com Essbase Data and Design Considerations Transactions tab Boring Oh sorry this is a necessary option but it s a setting that makes adjustments which never really help or hinder performance all that noticeably. Committing data after a certain number of transactions and not locking the entire database when calculating does have merit. We have never really had to play with these settings on large or small databases. You would need to have some sort of extreme situation involving conflicting and concurrent processes to facilitate any adjustment to these settings. Storage tab Here is one database property that definitely has merit These settings affect how and where Essbase stores your database page and index files the compression used and the type of I O used to read write the data. For starters the I O method can have a noticeable impact on performance when large data loads or transactions are involved. Buffered I O uses the operating system s file system and is the default setting. When more performance is needed the direct I O setting can be used. The direct I O setting provides
