hi,
In the sample init.ora file that came with our otm 5.5cu5 install, it sets cursor_sharing = SIMILAR
Does anyone have any experience setting this parameter, or not setting this parameter for OTM. We're early on in our implementation, but in the v$sqlarea I can see statements parsed by glogdba that are using bind variables, so I'm not sure why this is recommended?
We have a different purchased app that doesn't use bind variables, and we have set cursor_sharing = FORCE on that database, but I don't want to set this parameter on our OTM database if it's not really necessary. We're on oracle 10.2.0.4.
Thanks.
Karen Elder
Oracle Database Administrator
In the sample init.ora file that came with our otm 5.5cu5 install, it sets cursor_sharing = SIMILAR
Does anyone have any experience setting this parameter, or not setting this parameter for OTM. We're early on in our implementation, but in the v$sqlarea I can see statements parsed by glogdba that are using bind variables, so I'm not sure why this is recommended?
We have a different purchased app that doesn't use bind variables, and we have set cursor_sharing = FORCE on that database, but I don't want to set this parameter on our OTM database if it's not really necessary. We're on oracle 10.2.0.4.
Thanks.
Karen Elder
Oracle Database Administrator
Comment