thanks and regarding to number 2. I have trace the sql and the plan is very sufficient as I mentioned I used bind variable. the only thing I just want to make sure that it will do soft parse (memory) rather than hard parse. are there any parameters that I can tune?

Thanks,