My Oracle Support Banner

vo.executeQuery() Executes Query Twice in the Database When View Object Created (Doc ID 345144.1)

Last updated on MARCH 18, 2019

Applies to:

Oracle JDeveloper - Version 9.0.5.2.0 to 11.1.1.2.0 [Release AS10g to Oracle11g]
Information in this document applies to any platform.
***Checked for relevance on 25-Feb-2013***

Symptoms

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:

 

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
 Query is executed twice in the database
 Query can take time in the database to execute
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.