Home » RDBMS Server » Server Utilities » Export Issue - Takes more than 2 days (ORACLE - 9.2.0.4 HP-UX 11.11)
Export Issue - Takes more than 2 days [message #349471] Mon, 22 September 2008 00:25 Go to next message
jesuisantony
Messages: 132
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.

Regards,
Antony
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: 64152
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.

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


Current Time: Sun Dec 11 00:10:36 CST 2016

Total time taken to generate the page: 0.19657 seconds