Title: RE: Export Hanging
Mandar, did you have enough disk available for the export file? You don't say anything about checking your filesystem.
Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Mandar Shete [SMTP:[EMAIL PROTECTED
You're right Lisa, forgot to mention that. But we do have more than enough disk space
available. Everything else seems to be ok as well with the OS - logged in as
administrator, so no privilege issues either.
Mandar.
Koivu, Lisa wrote:
Mandar, did you have enough disk available for
Mandar - Have you checked you alert log to see if Oracle is writing anything
useful there? Maybe you have, I just didn't see where you mentioned it.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, October 22, 2001 8:50 AM
To: Multiple recipients of
Thanks Denis - I should have mentioned it - nothing in the alert log either.
Mandar.
[EMAIL PROTECTED] wrote:
Mandar - Have you checked you alert log to see if Oracle is writing anything
useful there? Maybe you have, I just didn't see where you mentioned it.
Dennis Williams
DBA
Lifetouch,
Hi Mandar,
We had similar problem when we did full db export. What we found was,
export process was hanging when it was reading one of the system table (in
our case, it is SYS.EXU8REFIC). When we saw the execution plan, it is using
ALL_ROWS (there are no stats on sys objects but still it is
Thanks Prasad. I have looked in Metalink but could not find anything that relates
exactly to my situation - as I mentioned before, I can't see any non-idle wait in
either v$session_wait or v$session_event. But I'll try tracing the session to see if
that helps (though I still can't figure out
recipients of list
ORACLE-L [EMAIL PROTECTED]
times.com cc:
Sent by: Subject: Re: Re: Export Hanging
