> 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 -- //www.freelists.org/webpage/oracle-l