My Oracle Support Banner

'Wrong' VPD Predicates Applied Using Sql Performance Analyzer via a DB LINK (Doc ID 1461308.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 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.

 

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
Cause
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.