986687 wrote:Your problem could be the Oracle licence. Express Edition can use only 1G of RAM and 1 CPU, whereas your 9i release may have had no such limits. You could buy a Standard Edition 1 licence, it is only USD180 per named user and then you can use the full power of your server.
Hello Rob J and thank you for your support.I have closely followed your questions and have also asked the oracle admin to , Get the DBA to look at the state of the DB, using AWR. I have also checked the CPU/DISK usage and the reports are normal.I will also disable the Firewall according to your suggestions and report back to you. Thank you very much for giving time to my problem.I will reply back to your questions once i get the full report.In the meantime, if you need any more data please let me know.