| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** keep/pin objects in sga
eagle fan,
Thanks. Can you give details about how to get advanced warning for serious ORA-4031 errors. I also read your other post about subpool and you are setting the param _kghdsidx_count to 2. Any advantages or disadvantages to setting this param to 2 instead of setting it to 1. I think 1 would simulate the 8i situation. Thanks
eagle fan <eagle.f_at_gmail.com> wrote:
hi:
If you have literal sql issue, I suggest you use bind variables rather than cusor_sharing.
The parameter cursor_space_for_time is used to pin shared sql in shared_pool. You can find more info about this parameter..
For advance warning, you can check the x$ tables: x$kghlu, x$ksmss, x$ksmsp
On 10/22/06, A Joshi <ajoshi977_at_yahoo.com > wrote: Fuad,
Thanks. So no short cut there. OK. So I guess we still need to do keeping of objects and sql. And put in bind variables. I assume there is some improvement in 9i in handling all this. Is there anything else that can be done to improve the sga usage and avoid its fragmentation and is there way to get advance warning when it is fragmented and could be heading for problems. Thanks
Fuad Arshad <fuadar_at_yahoo.com> wrote:
cursor sharing still has a lot of bugs.
it depends on the environment but tom kyte also asked for the use of this only at session level rather than system level
Hi,
For efficient use of shared pool and SGA : On 9i : I assume it is beneficial to keep objects and sql in sga. Or is it not needed on 9i? I think parameter CURSOR SHARING can be set to FORCE as alternative to using bind variables and that will help SGA use but there were issues with it. I assume in 9i it is better. Any body with experience otherwise or any other catch? Thanks for your help.
--
Eagle Fan
Oracle DBA
 |
 |