Re: Re: Export Hanging

2001-10-22 Thread Prasada . Gunda1
times.com> cc: Sent by: Subject: Re: Re: Export Hanging

Re: Re: Export Hanging

2001-10-22 Thread Mandar Shete
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 w

Re: Export Hanging

2001-10-22 Thread Prasada . Gunda1
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 do

Re: RE: Export Hanging

2001-10-22 Thread Mandar Shete
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, In

RE: Export Hanging

2001-10-22 Thread DENNIS WILLIAMS
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

Re: RE: Export Hanging

2001-10-22 Thread Mandar Shete
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

RE: Export Hanging

2001-10-22 Thread Koivu, Lisa
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 PROT