To ensure this unique entry, enter a relative path so that the cache is stored in the local writable directory for each Oracle BI Server, or enter different fully qualified paths for each server.
Ini File Settings Software Uses AnThe Oracle BI Server software uses an initialization file called NQSConfig.INI to set parameters upon startup.This initialization file includes parameters to customize behavior based on the requirements of each individual installation.The parameters are generally listed in the order in which they appear in the configuration file.
Parameters that are centrally managed by Fusion Middleware Control are marked as such in this appendix, and are also identified by comments in the NQSConfig.INI file. Ini File Settings Update These SettingsIf you must manually update these settings, then you must disable all configuration through Fusion Middleware Control (not recommended). If you omit the size qualifier, then the value is interpreted as the number of bytes. If you include the size qualifier, then ensure that you include a space before the qualifier. The errors are logged to the nqserver.log file, which is located in. For more information, see Section 4.1, About Starting and Stopping Oracle Business Intelligence. See Section 10.2, Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI Presentation Catalog Location for more information. However, hosting multiple repositories on a single Oracle BI Server is not recommended for production systems. Client tools use this name to configure the ODBC data sources that connect to the repository. To use a reserved keyword for the name, such as OCI7 or OCI8, enclose it in single quotation marks. The file name must have the.rpd file extension, and the file must reside in the repository subdirectory. After deciding on a strategy for flushing outdated entries, configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file. As the system is used over a period of time, performance tends to improve due to cache hits on previously executed queries. The most effective and pervasive way to optimize query performance is to use the Aggregate Persistence wizard and aggregate navigation. Ini File Settings How To Use CachingFor information about how to use caching in Oracle Business Intelligence, including information about how to use agents to seed the Oracle BI Server cache, see Chapter 7, Managing Performance Tuning and Query Caching. See Section 7.5.1, Using Fusion Middleware Control to Enable and Disable Query Caching for more information. For optimal performance, specify the paths on high-performance storage systems. UNC path names and network mapped drives are enabled only if the service runs under a qualified user account. For example, if you specify the path cache, then at runtime, the Oracle BI Server uses the following. Therefore, the DATASTORAGEPATHS entry must be unique for each clustered server.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |