vo.executeQuery() Executes Query Twice in the Database When View Object Created
(Doc ID 345144.1)
Last updated on JANUARY 30, 2022
Oracle JDeveloper - Version 18.104.22.168.0 to 22.214.171.124.0 [Release AS10g to Oracle11g] Information in this document applies to any platform.
Your application is using dynamic View Objects created by the method createViewObjectFromQueryStmt() You note performance problems when executing the method executeQuery() (or other method that in turn executes executeQuery() method, eg first(), ...) Setting up the BC4J trace (-Djbo.debugoutput=console) indicates that the SQL is executed twice:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!