Hello We have recently migrated Oracle 6i forms with a native runtime to 10g to work with web and java. It works but with huge performance problems. For example, in the server which is running red hat, switching between two screens in the web version 10g uses 15% cpu per client!!!
This is crazy and must be an error somewhere, because we have other applications running in 10g which was "made" for web but never existed in 6i, but switching normally between a screen is something like 0.5-2% cpu use, not 15% or even 20% like this is giving us.
What gives? Is there something we are missing in the migration between 6i and 10g here? If anyone has any idea, be it configuration or code etc please do tell!
Thanks!