Can you time how long an Oracle import takes?

I'm on a Windows machine with Oracle Client 11.1.0, and am going to import a database dump. I'm importing from the command line with the "imp" command.

Is there an option to time how long the import takes? I've searched around but haven't found anything for that yet.

Thanks in advance!

If you just want to time how long it takes, you could call it via a batch file like this:

echo %DATE% %TIME% >> time.log
imp parfile=./file.par etc etc
echo %DATE% %TIME% >> time.log

Once everything has run through, have a look at the time.log file and work out the difference between the 2 values.

StackExchange Database Administrators Q#24039, answer score: 3