Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

Execute in connect statement not getting picked

Question

Views

Comments

ips16 Rank 1 - Community Starter

Feb 18, 2019 10:35AM in Oracle Business Intelligence Applications

Hi,

I have been trying to use the execute on connect feature to run the query

alter session set query_rewrite_enabled = force

However it is not getting picked as I am checking in the nqserver logs.

have been stuck on this for days. any help would be appreciated.