Performance issues with turning off case sensitivity?
I read somewhere that if you turn off case sensitity in Oracle, you could have perform issues due to some kind of an index thing. Has anyone else experienced this? We are in the process of migrating to 10g and have considered turning this off, but if it's going to cost performance, we may need to rethink this. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Oracle 9i to 10g upgrade issues?
We are running ARS 6.3 patch 20 and need to upgrade our database to Oracle 10g from 9i. When you do this, you can't install Oracle on top of the previous version. Now that we have Oracle upgraded, remedy can't find the database. Has anyone had issues with this kind of an upgrade? Apparently Remedy hardcodes Oracle information that we will need to change. Any ideas? Thanks! Melissa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Mid Tier patch 20 issue with 9093/9350
Can anyone tell me exactly how to recreate this error? We have only had three users experience this problem and I need to write some sort of a workaround on how to prevent this. Is there a way to prevent this? When exactly does it happen? Thanks! Melissa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"