Skip to main content

Parallel execution forced to Serial execution

Sometimes, we think that simply using parallel execution of Sql, especially using Sql parallel hint will make our Sql query- standalone or embedded in PL/SQL become very fast and efficient.
However, there are some cases where Oracle in recent releases detected during the optimization phase that it can't use Parallel Execution, but has already started to generate a Parallel Execution plan.
So, it will convert the parallel execution to a Serial execution.
Please read here to know more.

Labels:

Comments

Post a Comment

Popular posts from this blog

India's exciting one wicket win over Australia in Mohali test

In an exciting finish in the first test match at Mohali, India beat Australia by 1 wicket. India had to make 216 to win, and at 1 stage India were 124 for 8. Then V.V.S.Laxman and Ishant Sharma had a superb partnership of 81 runs and took India to victory. Laxman remained unbeated on 73, and Ishant made 31. The place where I am currently staying does not subscribes to the sports channel showing this match, but I would surely love to watchthe highlights of this match.
Post a Comment
Read more

What is this street's name ?

This is another of my Chennai experiences. I had this experience on the street where I stayed at a guest house location till 30th September morning. The street on which I lived is called as "Neelkanda Mehta" street. However, on many homes as well as some other places, it is written as "Neelkanda Metha" street. I have asked other people too. However, I have not found a satisfactory answer.
Post a Comment
Read more

Evolution and Creationism - My Viewpoint

Whenever someone mentions something related to Evolution ; or whether God created all Animals , Humans ;or whether it is all a play of evolutionary Process; I become very much engrossed. It is a topic in which I have a unique interest . At a personal level,I favour the Theory of Evolution . True , the theory that God created everything does has its valid points . It also has many people supporting it . Points that make the God's creation Theory (as such this is not the name of the Theory , but I call it like this ) : 1)Evolutionists say that Man evolved from Apes who in turm evolved from some Amphibian creatures ,who in tuirn were evolving from Reptiles or Fish and so on . yet ; who created the most basic Life Form ? It must have been God . 2)Who decided when Big Bang has to happen or why Earth only had to be habitable long enough ? True , Mars also has some signs of Life Supporting conditions , but no Life has been detected as such . 3)Why Man only...
Post a Comment
Read more