| Export Issue - Takes more than 2 days [message #349471] |
Mon, 22 September 2008 00:25  |
jesuisantony
Messages: 166
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
