Home » parallel processing

parallel processing

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 »

How to monitor parallel queries in oracle database

Parallel execution is a important aspect of increasing throughput in oracle database.So often use Parallel execution in Oracle database. In this post, i will touch upon Important Parallel processing data dictionary views and How to monitor parallel queries in oracle database Parallel Processing Data Dictionary views In this section we are trying to give a …

How to monitor parallel queries in oracle database Read More »

Scroll to Top