-
SGA versus sharedpool
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|