Tag Archives: parallel processing

Parallel Processing Data Dictionary views Lesson 2

Comment

Last updated on July 17th, 2015 at 06:05 pm V$PQ_SLAVE and V$PX_PROCESSThese two views allow us to track whether individual slaves are in use or not and track down their associated sessiondetails.SQL> SELECT * FROM v$px_process; SERV STATUS           PID SPID                            SID    SERIAL#—- ——— ———- ———————— ———- ———-PZ98 AVAILABLE        112 19875PZ99 AVAILABLE        260 53611PZ97 AVAILABLE        387 20261 V$PQ_TQSTATThis view contains statistics on parallel execution operations. The … Continue reading Parallel Processing Data Dictionary views Lesson 2 »

Parallel Processing Data Dictionary views Lesson 1

Comment

Last updated on August 15th, 2015 at 05:50 pmIn 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_SYSSTATSome important views a)V$PQ_SESSTAT V$PQ_SESSTAT shows you PX statistics … Continue reading Parallel Processing Data Dictionary views Lesson 1 »

Oracle Database Parallel Processsing Decoded

Comment

Last updated on August 25th, 2016 at 04:46 amWhat is Parallel Processsing This allows a single SQL statement to be executed by a multiple processes executing concurrently on different CPUs.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 like CPU or I/O … Continue reading Oracle Database Parallel Processsing Decoded »