How Parallel execution works in Oracle database
What is Parallel Execution in Oracle database Parallel execution in oracle allows a single SQL statement to be executed by a multiple processes executing concurrently on different CPU’s. It increases throughput by utilizing more resources (Memory, CPU & I/O).It uses a pool of instance background processes (query slaves) .Based on Parallel Execution you are able …
How Parallel execution works in Oracle database Read More »