Tag Archives: Parallel Processing Data Dictionary views

Top 10 Parallel Processing Views and Monitoring Queries in Oracle Database

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 »