How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
1.206 PARALLEL_MIN_SERVERS → environment. 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
PARALLEL_MIN_SERVERS → reserved 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
4.3.4 Adjust Minimum and Maximum for Parallel Execution Servers → In 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
1.205 PARALLEL_MIN_PERCENT → PARALLEL_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 \"
ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string → Cause: 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.
ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string → Cause: 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
ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string → PARALLEL_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.
1.4.1 Parameters by Functional Category → PARALLEL_MIN_PERCENT PARALLEL_MIN_SERVERS PARALLEL_THREADS_PER_CPU PL/SQL PLSQL_V2_COMPATIBILITY
1.4.2 Modifiable Parameters → PARALLEL_MIN_SERVERS PARALLEL_MIN_TIME_THRESHOLD PARALLEL_SERVERS_TARGET PARALLEL_THREADS_PER_CPU
Optimizing Star Queries Using VECTOR GROUP BY Aggregation → is controlled by two initialization parameters parallel_max_servers and parallel_min_servers. While
Parameters Establishing Resource Limits for Parallel Operations → PARALLEL_MIN_PERCENT PARALLEL_MIN_SERVERS PARALLEL_MIN_TIME_THRESHOLD PARALLEL_SERVERS_TARGET
Contents → 1.204 PARALLEL_MAX_SERVERS 1.205 PARALLEL_MIN_PERCENT 1.206 PARALLEL_MIN_SERVERS 1.207
Parallel Execution Server Pool → available 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.
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
Default Parameter Settings → performance. PARALLEL_MIN_SERVERS 0 Specifies the number of parallel execution processes to be
Table 6-1 Initialization Parameters Important for Advanced Replication → … PARALLEL_MIN_SERVERS Default: 0 Range: 0 to value of PARALLEL_MAX_SERVERS Modifiable?: Yes Specifies the minimum