2 Replies Latest reply: Jun 20, 2011 10:42 PM by 822143 RSS

    Package executed in SQLPLUS on AIX is much slower than Windows

    822143
      Environment:
      OS:AIX
      DB:Oracle 10.2.0.2.0 - 64bit

      I executed a package:
      execute WLTEST.PKG_MM.CREATE_FILE_BY_COMPANY('COM1');
      on the same machine installed the DB in the command shell with SQLPLUS and got the result 20 minutes later,but when I changed to execute it on a windows machine in windows command shell with SQLPLUS it finished just in 5 seconds!

      Since the result is so strange I try to trace the execute process and I find when I open the trace for the session on AIX , amazingly the result get out in 5 seconds the same time with on windows!

      Can some one tell me why and how to solve it without opening the trace option? Many thanks!

      Edited by: user4751950 on 2011-6-15 上午1:20