This content has been marked as final. Show 3 replies
I think you need to check other processes running on the machine at the same time. Do you have other jobs running? If on linux, use 'ps -ef | grep oracle' to check. You may also want to check memory.
which version did you use? There are also some bugs there which impact the performance.
it is a dev box and nothing else is running. i got a dump from another db and importing it. the similar import on other databases are always quick. this is the only box where i have an issue. all boxes have identical build, except for the storage is different, but this dev box has ample space on its own.