Hi All,

I am on 10.2.0.4 and I have a quick question to clear out my doubt. when we use SGA_TARGET, we would let Oracle to manage its own memory so we don't need to specify the size for shared_pool, is it correct?

1. why from time to time, I have been reading and noticed that sga_target is used and shared_pool is also used and I bit confused.
2. there is a sql statement that was executed over 5 million times over the period of the batch job was ran, it is used bind variable, I wonder if there is anything esle that we can do to make it run faster.

Thanks all