Home » RDBMS Server » Server Utilities » Export Issue - Takes more than 2 days (ORACLE - HP-UX 11.11)
Export Issue - Takes more than 2 days [message #349471] Mon, 22 September 2008 00:25 Go to next message
Messages: 147
Registered: July 2006
Location: Chennai
Senior Member
Dear All,

An export was initiated two days before and it still runs. The database size is around 60G only. No error is thrown. The session just hangs. Not sure if it will continue or what is happeneing in the background. Even the log file has the same contents as thet of console screen.

Please help in getting rid of this issue.

Re: Export Issue - Takes more than 2 days [message #349499 is a reply to message #349471] Mon, 22 September 2008 01:52 Go to previous message
Michel Cadot
Messages: 65133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate a trace on the process associated to the export and see what it does.
You can also follow IO/gets statistics in v$sesstat to see if they increase and check v$session_wait ot see if it is waiting.

Previous Topic: Importing Oracle 10 dump exported via Oracle 9.0 export utility
Next Topic: Ctl file doubts
Goto Forum:

Current Time: Wed Aug 16 10:22:03 CDT 2017

Total time taken to generate the page: 0.11289 seconds