This content has been marked as final. Show 2 replies
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.
Thanks for your reply.
The cache was eliminated by trying execute it on AIX right after on windows.