Re: Performance Tuning: shared memory

Thank you for you reply. I was concerned with the SQL hit ratio. It should be in the high 90s. But our app uses some third party product that uses little or no bind variables.

As my understanding, cursor_sharing is available on 816 and up. We are running 8.1.5. Checked the V$parameter, did not see this one.

Helen

"FSN" <cyberming_at_hotmail.com> wrote in message news:<9qkvhm$ntjs6$1_at_ID-58123.news.dfncis.de>...
> Your SQL area Hit ratio is really too low.If you 've consistently large
> amount of free memory available in v$sgstat then increasing Shared_Poll
> size would'nt do any good probabaly.IMHO single most helpful factor will be
> use of bind variable OR u can try Cursor_Sharing =Force init.ora parameter
> which forces Optimizer to use Shared SQl but this must be tested on Dev
> throughly as some clients reported getting ORA-600 error messages.
>
> Anwer
Received on Fri Oct 19 2001 - 10:18:42 CDT