Physical SQL Runs More Slowly In The BI Server (OBIEE) Than In SQL Plus
Last updated on JUNE 28, 2017
Applies to:Business Intelligence Server Administrator - Version 10.1.3.4.1  and later
Information in this document applies to any platform.
Physical SQL, per the OBIEE session log, runs in 3-5 seconds in SQL Plus, but takes 35-40 minutes to run on the BI Server, using nqcmd.
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