My Oracle Support Banner

SQL Performance Analyzer Report Shows ORA-16950 For Queries Using Database Link (Doc ID 3016016.1)

Last updated on APRIL 11, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.0.0.0 and later
Information in this document applies to any platform.

Symptoms

The SQL Performance Analyzer (SPA) report generated after running the SPA outputs ORA-16950 for a query that uses a database link to access remote objects.

　ORA-16950: Remote mapped cursors are not supported by this feature.



Changes

 Run the SPA with the SQL Tuning Set (STS) containing queries that access remote objects using database link.

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
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.