My Oracle Support Banner

OBIEE 12c: Two SQL Sessions Created When Executing DDR Reports (Doc ID 2571198.1)

Last updated on AUGUST 02, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 to 12.2.1.4.0 [Release 12c to 12g]
Information in this document applies to any platform.

Symptoms

On: Oracle Business Intelligence Enterprise Edition

When a direct database request(DDR) is executed, it creates two SQL sessions that can be verified by querying V$SQL_MONITOR. This leads to additional overhead to the database and causes performance issue.

First SQL session runs for sometime and the status becomes "DONE (FIRST N ROWS)" and then second one starts for the same DDR SQL and completes with status "DONE (ALL ROWS)"

The behavior can be monitored by executing the below query when the agent is running :

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


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