Tag Archives: Parallel Processing Data Dictionary views

Parallel Processing Data Dictionary views Lesson 1

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 »