My Oracle Support Banner

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 FEBRUARY 03, 2019

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

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.