How to check degree of parallelism in oracle & Default Parallelism
Suppose we execute the below parallel 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 be used for parallel processing …
How to check degree of parallelism in oracle & Default Parallelism Read More »
