12c: SQL Based on a View Object Executed as the SCHEMA Owner Runs Degraded As Compared to Execution Results for a Non-SCHEMA Owner
Last updated on MAY 24, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- A query with <SCHEMA>.<VIEW_NAME> syntax competes in a short duration while the query without the explicit schema name prefix completes in a much longer duration and may cause applications to time-out if they are set query timeouts within the application configuration. i.e seconds versus minutes (Long Duration)
There was no documented change in the 12c database or 3rd Party Vendor Application.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms