You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for OPTIMIZER_ADAPTIVE_REPORTING_ONLY


1 to 8 of 8 results.


Database Reference, 12c Release 1 (12.1)

OPTIMIZER_ADAPTIVE_REPORTING_ONLY

1.182 OPTIMIZER_ADAPTIVE_REPORTING_ONLYSYSTEM Modifiable in a PDB Yes Range of values TRUE | FALSE Basic No OPTIMIZER_ADAPTIVE_REPORTING_ONLY … controls reporting-only mode for adaptive optimizatons. When OPTIMIZER_ADAPTIVE_REPORTING_ONLY is … OPTIMIZER_ADAPTIVE_REPORTING_ONLY is set to TRUE, adaptive optimizations run in reporting-only mode

Database SQL Tuning Guide, 12c Release 1 (12.1)

Influencing the Optimizer

Controlling Adaptive Optimizationlater. The OPTIMIZER_ADAPTIVE_REPORTING_ONLY initialization parameter is set to false (default). If … OPTIMIZER_ADAPTIVE_REPORTING_ONLY is set to true, then adaptive optimization runs in reporting-only … OPTIMIZER_ADAPTIVE_REPORTING_ONLY initialization parameter is set to false (default). You want to … OPTIMIZER_ADAPTIVE_REPORTING_ONLY

Database SQL Tuning Guide, 12c Release 1 (12.1)

Query Optimizer Concepts

In Oracle Database, adaptive query optimization is the process by which the optimizer adapts an execution…OPTIMIZER_ADAPTIVE_REPORTING_ONLY initialization parameter is set to the default of false. See Also: \" Controlling Adaptive Optimization \"

Database Reference, 12c Release 1 (12.1)

Modifiable Parameters

1.4.2 Modifiable ParametersOPTIMIZER_ADAPTIVE_REPORTING_ONLY OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES OPTIMIZER_DYNAMIC_SAMPLING … OPTIMIZER_ADAPTIVE_REPORTING_ONLY OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES OPTIMIZER_DYNAMIC_SAMPLING OPTIMIZER_FEATURES_ENABLE

Database SQL Tuning Guide, 12c Release 1 (12.1)

Influencing the Optimizer

About Optimizer Initialization Parametersbuffers. OPTIMIZER_ADAPTIVE_REPORTING_ONLY Controls the reporting mode for automatic reoptimization and

Database Reference, 12c Release 1 (12.1)

Parameters by Functional Category

1.4.1 Parameters by Functional CategoryOPTIMIZER_ADAPTIVE_REPORTING_ONLY OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES OPTIMIZER_DYNAMIC_SAMPLING

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents1.182 OPTIMIZER_ADAPTIVE_REPORTING_ONLY 1.183 OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES 1.184

Database Reference, 12c Release 1 (12.1)

Changes in This Release for Oracle Database Reference

New FeaturesOPTIMIZER_ADAPTIVE_REPORTING_ONLY PDB_FILE_NAME_CONVERT PGA_AGGREGATE_LIMIT PROCESSOR_GROUP_NAME NONCDB_COMPATIBLE