RE: Parallel slaves blocking each other during CTAS with Parallel
From: Randolf Geist <info_at_www.sqltools-plusplus.org>
Date: Tue, 17 Dec 2013 10:01:05 +0100 (CET)
Message-ID: <35731.160.83.30.184.1387270865.squirrel_at_sqltools-plusplus.org>
> Thanks All..
> The version of the oracle is 11.2.0.3. I found the below
> article which explains about the root cause of blocking sessions during the
> parallel processes
> http://www.oracle.com/technetwork/articles/database-performance/geist-parallel-execution-1-1872400.html
> Thanks.
Date: Tue, 17 Dec 2013 10:01:05 +0100 (CET)
Message-ID: <35731.160.83.30.184.1387270865.squirrel_at_sqltools-plusplus.org>
> Thanks All..
> The version of the oracle is 11.2.0.3. I found the below
> article which explains about the root cause of blocking sessions during the
> parallel processes
> http://www.oracle.com/technetwork/articles/database-performance/geist-parallel-execution-1-1872400.html
> Thanks.
Whether the article explains what you encounter depends on how you define "blocking" - you haven't provided yet any further details how you've determined that there is some kind of blocking going on and what you exactly mean by "blocking".
Randolf
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 17 2013 - 10:01:05 CET