DB:Oracle 10.2.0.2.0 - 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
Without information on the data or the package, my first guess is that your first (20 minute) run fetched all the data from disk, loading into the buffer cache. When you ran sqlplus from Windows, it only had to read data from memory, not disk, and was able to return much faster. When you checked again on AIX, it read from memory again, hence the same performance as on Windows.