'Wrong' VPD Predicates Applied Using Sql Performance Analyzer via a DB LINK
Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Server - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
When running SQL Performance Analyzer (DBMS_SQLPA) via a Database Link and the Target Database has VPD set up, the VPD predicates applied to the queries run by SQLPA do not match those that should be applied given the Parsing Schema for a given captured query in a SQL Tuning Set.
For Example: The Database Link below connects to the a Target Database as SYSTEM, then use this database link to execute SQLPA Analysis Task. The Parsing Schema Name for the given query in the Sql Tuning Set is TEST.
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