>According to my friend who is a very experienced Oracle DBA there is a way to change/control execution plan in Oracle. He even told me how he does but of course I forgot :). He told me that the same SQL Select could take from 5 seconds to several hours depending on the execution plan.
>
I guess I need to research on this topic, thanks.