How to set Environment Variables for 11g on Windows 2003 Server x64 ?
I installed Oracle 11g on Windows 2003 Server x64 and migrated an instance previously running on 10g / Windows 2003 Server x32.
Performance was extremely slow in APEX and SQL. For the last 2 months we have been trying to find out the reason.
Yesterday I found out that environment variables ORACLE_HOME and PERL5LIB were not setup on Windows, they were blank.
I put this values there
ORACLE_HOME: D:\oracle\product\11.1.0\db_1
PERL5LIB: D:\oracle\product\11.1.0\db_1\sysman\admin\scripts
restarted the server and the instance performance is quite good.
I have 2 questions:
1. Are there other environment variables that should be set up to have the system running more efficiently / faster?
2. Is the PERL5LIB path correct? I tried to copy it from a 10g instance, but the path does not exist on 11g. I picked up a similar directory.
If is there is a document reference for Oracle 11g on Windows 2003 Server x64 it will be welcome.
Francisco