Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘Cache Management’ Category

Cache Management in 10g

Posted by Santosh Kumar Gidadmani on November 4, 2010

The query cache allows the Oracle BI Server to satisfy many subsequent query requests without having to access back-end databases.
Cache Parameters in NQSConfig.INI

Most of the configurations are provided on the NQSConfig.INI.

Steps to configure Cache strategies…

As updates occur on the back-end databases, the query cache entries can become stale. Therefore, Oracle BI Administrators need to periodically remove entries from the query cache using one of the following methods.                                                                                                                                                                  

Methods of Purging cache entries

  1. Configuring cache parameters in the NQSConfig.INI
  2. Controlling cache at physical layer in Administrator tool
  3. Using Cache manager to manually purge cache entries
  4. Automatically purging cache entries
  5. Seeding cache and event pooling table

Posted in Cache Management, OBIEE 10g, OBIEE 10g RPD | Tagged: | Leave a Comment »

%d bloggers like this: