Tag Archives: Parallel Query Option

how to check degree of parallelism in oracle & Default Parallelism

Last updated on September 1st, 2019 at 05:38 pmhow to check degree of parallelism in oracle Suppose we execute the below query in Oracle database select /*+ PARALLEL(JN) */ count(*) from ar.RA_INTERFACE_LINES_ALL jn; Here we can see , we have not specified the degree of the parallelism.Now there are two cases i. if we have defined degree at the table level, then that degree will … Continue reading how to check degree of parallelism in oracle & Default Parallelism »