This discussion is archived
2 Replies Latest reply: Jun 20, 2011 8:42 PM by 822143 RSS

Package executed in SQLPLUS on AIX is much slower than Windows

822143 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points