My Oracle Support Banner

OBIEE 11g - Reports sourced from PostgreSQL Database using DataDirect 7.0.1 ODBC Driver Doesn't Execute Simultaneously (Doc ID 2117169.1)

Last updated on JANUARY 24, 2022

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Linux x86-64


On using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g and getting data from PostgreSQL database using DataDirect 7.0.1 ODBC driver, it is noticed that the OBIEE reports are executed one after the other and there is an issue with the performance in the execution of the reports.

For example:

There are 2 reports as described below:

Report01, with small number of records-> This report returns results in seconds.
Report02, with huge number of records->This report returns results in minutes.

Test1 -

1. Execute Report01 by TestUser1.
2. Execute Report02 by TestUser2.

In this scenario, it is noticed that Report01 returns results in seconds and Report02 returns results in minutes.

Test2 -

1. Execute Report01 by TestUser2.
2. Execute Report02 by TestUser1.

In this scenario, it is noticed that Report01 returns results in minutes and it looks like Report01 is waiting for Report02 to finish.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.