We have just upgraded a development database from Oracle 8.1.6 to Oracle 18.104.22.168. We use a content management system that uses Intermedia Text and this option has also been upgraded.
Following the upgrade the response time for free text searching has become unacceptably slow. It looks like the Intermedia indexes are not being used?
Does anyone have experience of upgrading Oracle dbs with Intermedia? Any suggestions or ideas would be appreciated?