Vertaling van "parallel execution servers" in Japans
We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
Number of times per second parallel execution was requested and the degree of parallelism was reduced to 25% and more because of insufficient parallel execution servers.
The next level shows statistics aggregated by each type of parallel execution servers: parallel coordinator, parallel set 1, and optionally parallel set 2 for more complex execution plans, where the two sets of servers are working in parallel as a pipeline. The final level of the hierarchy shows the statistics associated with individual parallel execution server processes within each parallel set.
The number of parallel execution servers assigned to a single operation represents the degree of parallelism for an first number shows the degree of parallelism. The second number, if present, shows the number of instances involved in the parallel execution.
Temporary tablespace groups enable users to consume temporary space from multiple tablespaces. Using a tablespace group, rather than a single temporary tablespace, can alleviate problems caused when one tablespace is inadequate to hold the results of a sort, particularly on a table that has many partitions. A tablespace group enables parallel execution servers in a single parallel operation to use multiple temporary tablespaces.
If the execution is cross-instance, a check-box shows (respectively hide) the instance level from the hierarchy. Not showing the instance level in the hierarchy enables you to easily see the statistics for all parallel execution servers within a set. Ideally, for good scalability of the parallel execution, it is expected that the query coordinator performs a negligible amount of work. Also, the execution should present a minimal amount of skew; each server within a parallel set should perform about the same amount of work. On the other hand, statistics between the two sets of parallel execution server processes are expected to be different, because the two parallel sets are processing different operations of the execution plan.
The Resource Plans property sheet, allows you to choose available groups/subplans to include in the resource plan, select the percentage of CPU resources allocated to a group, specify the maximum number of parallel execution servers associated with a single operation for each resource consumer group, specify the maximum number of concurrently active sessions allowed within a consumer group, specify a maximum in kilobytes on the total amount of undo generated by a consumer group, specify a maximum execution time in seconds allowed for an operation if there were no other work on the system, specifying criteria that causes the automatic switching of sessions to another consumer group, and then activate the plan.
Number of parallel execution servers that may concurrently mine the redo log.
REDOログを同時にマイニングできるパラレル実行サーバーの数。
The parallel button only appears if the execution is parallel. Clicking this button shows monitoring statistics for the set of parallel execution servers allocated to run the SQL statement. These monitoring statistics are the same as those shown for the overall execution: database time, wait activity, IO count, and buffer gets.
You can use Oracle Enterprise Manager to enable parallel execution servers in a single parallel operation to use multiple temporary tablespaces. A tablespace group name can appear where a tablespace name would appear when assigning a default temporary tablespace for the database or assigning a temporary tablespace for a user.
On the Parallelism page, change the maximum number of parallel execution servers associated with a single operation for each resource consumer group. For detailed information on the Parallelism page, refer to Resource Plan: Parallelism.
Partitionwise joins reduce query response time by minimizing the amount of data exchanged among parallel execution servers when joins execute in parallel. This significantly reduces response time and improves the use of both CPU and memory resources. In Oracle Real Application Clusters environments, partitionwise joins also avoid or at least limit the data traffic over the interconnection, which is the key to achieving good scalability for massive join operations.
パーティションワイズ結合では、結合がパラレルで実行される場合にパラレル実行サーバー間で交換されるデータの量を最小化することにより問合せのレスポンス時間が削減されます。これによりレスポンス時間が大幅に削減され、CPUおよびメモリー・リソース両方の使用量を改善します。Oracle Real Application Clusters環境では、パーティションワイズ結合は相互接続のデータ通信を回避するか、少なくとも制限します。このことは大規模な結合操作に対する良質なスケーラビリティを実現するために重要です。
Potentieel gevoelige of ongepaste informatie
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.