Tag Archives: parallel processing

Top 10 Parallel Processing Views and Monitoring Queries in Oracle Database

Comment

Last updated on September 1st, 2019 at 06:01 pmParallel Processing Data Dictionary views In this section we are trying to give a glimpse of Parallel Processing Data Dictionary views Oracle keep changing the view name,but below query should be able to give all the views SELECT table_name FROM dict WHERE table_name LIKE ‘V%PQ%’ OR table_name like ‘V%PX%‘; Examples V$PX_SESSION V$PX_SESSTAT V$PX_PROCESS V$PX_PROCESS_SYSSTAT Some important views … Continue reading Top 10 Parallel Processing Views and Monitoring Queries in Oracle Database »

How Parallel execution works in Oracle database

Comment

Last updated on September 1st, 2019 at 05:44 pmWhat is Parallel Execution in Oracle database This 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 to use more system resources … Continue reading How Parallel execution works in Oracle database »