2 Replies Latest reply on Jun 21, 2011 3:42 AM by 822143

    Package executed in SQLPLUS on AIX is much slower than Windows

      DB:Oracle - 64bit

      I executed a package:
      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