OBIEE 11g Event Pooling Table:

OBIEE 11g Event Pooling Table:

Event Pooling table is used to notify the Oracle BI Server that one or more physical tables have been updated and query cache entries on these tables are stale.

A row is added to the event pool table when the table is updated. BI Server is pools the table and extract the information of the updated table and purge the cache entries related to the tables.

Configuring the Event Pool Table:

Event Pool table has fixed schema and created in the database.

Event Pool table script:

CREATE TABLE S_NQ_EPT (

  UPDATE_TYPE    DECIMAL(10,0)  DEFAULT 1       NOT NULL,

  UPDATE_TS      DATE           DEFAULT SYSDATE NOT NULL,

  DATABASE_NAME  VARCHAR2(120)  NULL,

  CATALOG_NAME   VARCHAR2(120) NULL,

  SCHEMA_NAME    VARCHAR2(120) NULL,

  TABLE_NAME     VARCHAR2(120) NOT NULL,

  OTHER_RESERVED VARCHAR2(120)  DEFAULT NULL  NULL 

) ;

The table is available in BIPLATFORM Schema.

1. Import the table in to the physical layer

2. Go to Utilities and select Oracle BI Event tables then execute

3. Select the table from the list and give the pooling frequency