My Oracle Support Banner

Can A SQL Profile Be Imported Without Tuning Pack License (Doc ID 2962161.1)

Last updated on OCTOBER 06, 2023

Applies to:

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

Goal

A SQL Profile is working in source database as expected with Oracle Enterprise Edition and Diagnostic and Tuning Pack license.
A new database server has been created without Diagnostic and Tuning Pack licenses.
The same query on the new servers is running slow and has a different execution plan than the source database server.

Can a SQL Profile be exported from source database and imported into the target database without Diagnostic and Tuning Pack license using one of the following notes?

How to Move SQL Profiles from One Database to Another (Including to Higher Versions) (<Document ID 457531.1>)

Encouraging CBO to Pickup a Better Execution Plan Using the COE XFR SQL Profile Script (<Document ID 1955195.1>)

Solution

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