OBIEE 11g: Dashboard Performance Degrades Significantly When Using An SSL Enabled SQL*Net /OCI Listener And SSL_CERT_REVOCATION=NONE (Doc ID 2041337.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.141014 and later
Information in this document applies to any platform.

Symptoms

OBIEE 11.1.1.7.xxx version
Oracle Database 11.2.0.4

ACTUAL BEHAVIOR
---------------
Dashboards tab is taking anywhere from 30 seconds to two minutes to display the dashboard prompts.


EXPECTED BEHAVIOR
-----------------------
Dashboard prompts should be displayed instantly


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. login into analytics
2. open dashboard with prompts, but other performance manifestations may be observed

ADDITIONAL INFORMATION:
-----------------------------------

This behavior is not observed using non-SSL enabled SQL*Net / OCI listener.
This behavior was working with SSL enabled SQL*Net / OCI listener prior to a specific date.
The sqlnet.ora on the OBIEE Server ("client" side) includes SSL_CERT_REVOCATION=NONE
The issue is observed in multiple environments.



Changes

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms