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 188.8.131.52.0 to 184.108.40.206.0 [Release 12c to 12g]
Information in this document applies to any platform.
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 :
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