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 PARALLEL_MIN_SERVERS


1 to 17 of 17 results.


Database Reference, 12c Release 1 (12.1)

PARALLEL_MIN_SERVERS

1.206 PARALLEL_MIN_SERVERSenvironment. PARALLEL_MIN_SERVERS is the number of parallel execution processes Oracle creates when … value for the PARALLEL_MIN_SERVERS parameter in the table above, the database sets the default … value of PARALLEL_MIN_SERVERS to a value that is lower than the documented default value. The lower

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

PARALLEL_MIN_SERVERS

PARALLEL_MIN_SERVERSreserved for parallel operations. Setting PARALLEL_MIN_SERVERS balances the startup cost against memory … usage. Processes started using PARALLEL_MIN_SERVERS do not exit until the database is shut down. This … Reference for information about the PARALLEL_MIN_SERVERS initialization parameter

Database Upgrade Guide, 12c Release 1 (12.1)

Post-Upgrade Tasks for Oracle Database

4.3.4 Adjust Minimum and Maximum for Parallel Execution ServersIn Oracle Database 12 c the default for PARALLEL_MIN_SERVERS has been changed from 0 to a value … the default in your old environment, no actions are needed. See Also: Oracle Database Reference for information about PARALLEL_MIN_SERVERS

Database Reference, 12c Release 1 (12.1)

PARALLEL_MIN_PERCENT

1.205 PARALLEL_MIN_PERCENTPARALLEL_MIN_SERVERS = 5 PARALLEL_MAX_SERVERS = 10 If 8 of the 10 parallel execution processes are busy, only 2 … \" PARALLEL_DEGREE_POLICY \", \" PARALLEL_MAX_SERVERS \", \" PARALLEL_MIN_SERVERS \", and \" PARALLEL_ADAPTIVE_MULTI_USER \"

Database Error Messages, 12c Release 1 (12.1)

ORA-12700 to ORA-19400

ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, stringCause: An attempt was made to set the PARALLEL_MIN_SERVERS parameter to a value higher than … PROCESSES. Action: Set PARALLEL_MIN_SERVERS to a value less than PROCESSES value specified in the accompanying message and retry.

Database Error Messages, 12c Release 1 (12.1)

ORA-12700 to ORA-19400

ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, stringCause: An attempt was made to set the PARALLEL_MIN_SERVERS parameter to a value higher than … PARALLEL_MAX_SERVERS. Action: Set PARALLEL_MIN_SERVERS to a value less than or equal to

Database Error Messages, 12c Release 1 (12.1)

ORA-12700 to ORA-19400

ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, stringPARALLEL_MIN_SERVERS. Action: Set PARALLEL_MAX_SERVERS to a value greater than or equal to … PARALLEL_MIN_SERVERS value specified in the accompanying message and retry.

Database Reference, 12c Release 1 (12.1)

Parameters by Functional Category

1.4.1 Parameters by Functional CategoryPARALLEL_MIN_PERCENT PARALLEL_MIN_SERVERS PARALLEL_THREADS_PER_CPU PL/SQL PLSQL_V2_COMPATIBILITY

Database Reference, 12c Release 1 (12.1)

Modifiable Parameters

1.4.2 Modifiable ParametersPARALLEL_MIN_SERVERS PARALLEL_MIN_TIME_THRESHOLD PARALLEL_SERVERS_TARGET PARALLEL_THREADS_PER_CPU

Database Data Warehousing Guide, 12c Release 1 (12.1)

Data Warehousing Optimizations and Techniques

Optimizing Star Queries Using VECTOR GROUP BY Aggregationis controlled by two initialization parameters parallel_max_servers and parallel_min_servers. While

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Parameters Establishing Resource Limits for Parallel Operations

Parameters Establishing Resource Limits for Parallel OperationsPARALLEL_MIN_PERCENT PARALLEL_MIN_SERVERS PARALLEL_MIN_TIME_THRESHOLD PARALLEL_SERVERS_TARGET

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents1.204 PARALLEL_MAX_SERVERS 1.205 PARALLEL_MIN_PERCENT 1.206 PARALLEL_MIN_SERVERS 1.207

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Parallel Execution Server Pool

Parallel Execution Server Poolavailable for any parallel operation. The initialization parameter PARALLEL_MIN_SERVERS specifies the … reduce the size of the pool less than the value of PARALLEL_MIN_SERVERS, no matter how long the parallel execution servers have been idle.

Database Advanced Replication, 12c Release 1 (12.1)

Master Replication Concepts and Architecture

Parallel propagation uses the pool of available parallel processes. This is the same facility Oracle…If a scheduled job with a 60 minute interval wakes up at 2:30 pm and checks the deferred transaction queue, then any existing deferred transactions are propagated. The propagation takes 2 minutes and therefore the job is complete at 2:32 pm. If a deferred transaction enters the queue at 2:34 pm, then the deferred transaction is not propagated because the job is complete. In this scenario, the deferred

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Default Parameter Settings

Default Parameter Settingsperformance. PARALLEL_MIN_SERVERS 0 Specifies the number of parallel execution processes to be

Database Advanced Replication, 12c Release 1 (12.1)

Planning Your Replication Environment

Table 6-1 Initialization Parameters Important for Advanced ReplicationPARALLEL_MIN_SERVERS Default: 0 Range: 0 to value of PARALLEL_MAX_SERVERS Modifiable?: Yes Specifies the minimum

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Database VLDB and Partitioning Guide - Contents

Contentsfor a User using a Consumer Group PARALLEL_MIN_PERCENT PARALLEL_MIN_SERVERS