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 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----- Sent: Monday, October 22, 2001 9:50 AM To: Multiple recipients of list ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705 Content-Type: text/plain; charset=us-ascii Hi All, Oracle 8.1.6.1 NT 4 SP5 I'm facing a problem with all exports hanging on our production database. Tried it several times, but the export seems to get stuck at different points each time. The strange part is that at this point v$session_event shows absolutely nothing happening - all the wait numbers just freeze indefinitely and v$session_wait shows a 'SQL*Net message from client' wait - the session seems to be doing nothing at all. This is the output from v$session_event for my latest try SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS 63 latch free 2 2 63 db file sequential read 8 0 63 db file scattered read a95 0 63 file open 3 0 63 SQL*Net message to client $4859 0 63 SQL*Net more data to client 9282 0 63 SQL*Net message from client $4858 0 I'm running this on the server itself, so the network's not an issue. Tried different export modes and parameters (full, owner, tables, buffer, direct, etc.) but with the same result. I'm pretty new to this site, but I'm told that this problem's been there for some time now but was never really taken seriously since we don't take regular exports. I'm about to raise a TAR on this one, but any pointers before that would be useful. TIA, Mandar. Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in --=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705 Content-Type: text/html; charset=us-ascii <BR><BR>Hi All, <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"> <P>Oracle 8.1.6.1 NT 4 SP5</P> <P>I'm facing a problem with all exports hanging on our production database. Tried it several times, but the export seems to get stuck at different points each time. The strange part is that at this point v$session_event shows absolutely nothing happening - all the wait numbers just freeze indefinitely and v$session_wait shows a 'SQL*Net message from client' wait - the session seems to be doing nothing at all. This is the output from v$session_event for my latest try</P> <P>SID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EVENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOTAL_WAITS&nbsp; TOTAL_TIMEOUTS<BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; latch free&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&! ! ! amp;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db file sequential read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0<BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb! ! ! sp;db file scattered read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a95&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 <BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; file open&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR>63&a! ! ! mp;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net message to client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $4859&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp; <BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net more data to client&nbsp;&nbsp;&nbsp; 9282&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp! ! ! ;&nbsp;0&nbsp; <BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQL*Net message from client&nbsp;&nbsp;244858&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR></P> <P>I'm running this on the server itself, so the network's not an issue. Tried different export modes and parameters (full, owner, tables, buffer, direct, etc.) but with the same result. I'm pretty new to this site, but I'm told that this problem's been there for some time now but was never really taken seriously&nbsp;since we don't take regular exports.</P> <P>I'm about to raise a TAR on this one, but any pointers before that would be useful.</P> <P>TIA,</P> <P>Mandar.</P> <P>&nbsp;</P> <P>&nbsp;</P></BLOCKQUOTE> <hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at </font><a href="http://email.indiatimes.com"><font face="Arial" size="2">http://email.indiatimes.com</font></a></b><br>Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from <A href="http://www.planetm.co.in">http://www.planetm.co.in</A> --=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Shete INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) S8-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in --=_MAILER_ATTACH_BOUNDARY1_2001102212023232124898138 Content-Type: text/html; charset=us-ascii <P>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.</P> <P>Mandar.</P> <P><BR><BR><B><I>"Koivu, Lisa"<[EMAIL PROTECTED]></B></I> wrote: <BR></P> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <META content="MS Exchange Server version 5.5.2653.12" name=Generator> <P><FONT color=#0000ff face=Georgia>Mandar, did you have enough disk available for the export file? You don't say anything about checking your filesystem.</FONT> </P> <P><FONT face=Georgia>Lisa Koivu</FONT> <BR><FONT face=Georgia>Oracle Database Monkey</FONT> <BR><FONT face=Georgia>Fairfield Resorts, Inc.</FONT> <BR><FONT face=Georgia>954-935-4117</FONT> </P><BR> <UL> <P><FONT face=Arial size=1>-----Original Message-----</FONT> <BR><B><FONT face=Arial size=1>From: </FONT></B> <FONT face=Arial size=1>Mandar Shete [SMTP:[EMAIL PROTECTED]]</FONT> <BR><B><FONT face=Arial size=1>Sent: </FONT></B> <FONT face=Arial size=1>Monday, October 22, 2001 9:50 AM</FONT> <BR><B><FONT size=1 úCE="Arial">To: </FONT></B> <FONT size=1 úCE="Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT size=1 úCE="Arial">Subject: </FONT></B> <FONT face=Arial size=1>Export Hanging</FONT> </P> <P><FONT size=2 úCE="Arial">--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705</FONT> <BR><FONT face=Arial size=2>Content-Type: text/plain; charset=us-ascii</FONT> </P><BR> <P><FONT face=Arial size=2>Hi All,</FONT> </P><BR><BR> <P><FONT face=Arial size=2>Oracle 8.1.6.1 NT 4 SP5</FONT> </P><BR> <P><FONT face=Arial size=2>I'm facing a problem with all exports hanging on our production database. Tried it several times, but the export seems to get stuck at different points each time. The strange part is that at this point v$session_event shows absolutely nothing happening - all the wait numbers just freeze indefinitely and v$session_wait shows a 'SQL*Net message from client' wait - the session seems to be doing nothing at all. This is the output from v$session_event for my latest try</FONT></P><BR> <P><FONT size=2 úCE="Arial">SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS</FONT> <BR><FONT size=2 úCE="Arial">63 latch free 2 2</FONT> <BR><FONT size=2 úCE="Arial">63 db file sequential read 8 &nb! ! ! sp; 0</FONT> <BR><FONT size=2 úCE="Arial">63 db file scattered read a95 0 </FONT><BR><FONT size=2 úCE="Arial">63 file open 3 0</FONT> <BR><FONT size=2 úCE="Arial">63 SQL*Net message to client $4859 0 </FONT><BR><FONT size=2! ! ! úCE="Arial">63 SQL*Net more data to client 9282 0 </FONT><BR><FONT size=2 úCE="Arial">63 SQL*Net message from client $4858 0</FONT> </P><BR><BR> <P><FONT face=Arial size=2>I'm running this on the server itself, so the network's not an issue. Tried different export modes and parameters (full, owner, tables, buffer, direct, etc.) but with the same result. I'm pretty new to this site, but I'm told that this problem's been there for some time now but was never really taken seriously since we don't take regular exports.</FONT></P><BR> <P><FONT face=Arial size=2>I'm about to raise a TAR on this one, but any pointers before that would be useful.</FONT> </P><BR> <P><FONT face=Arial size=2>TIA,</FONT> </P><BR> <P><FONT face=Arial size=2>Mandar.</FONT> </P><BR> <P><FONT face=Arial size=2> </FONT> </P><BR> <P><FONT face=Arial size=2> </FONT> <BR><FONT face=Arial size=2>Get Your Private, Free E-mail from Indiatimes at <A href="http://email.indiatimes.com/" target=_blank>http://email.indiatimes.com</A></FONT> <BR><FONT face=Arial size=2>Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from <A href="http://www.planetm.co.in/" target=_blank>http://www.planetm.co.in</A></FONT> </P> <P><FONT size=2 úCE="Arial">--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705</FONT> <BR><FONT face=Arial size=2>Content-Type: text/html; charset=us-ascii</FONT> </P> <P><FONT face=Arial size=2><BR><BR>Hi All,</FONT> <BR><FONT face=Arial size=2><BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"></FONT> <BR><FONT face=Arial size=2><P>Oracle 8.1.6.1 NT 4 SP5</P></FONT> <BR><FONT face=Arial size=2><P>I'm facing a problem with all exports hanging on our production database. Tried it several times, but the export seems to get stuck at different points each time. The strange part is that at this point v$session_event shows absolutely nothing happening - all the wait numbers just freeze indefinitely and v$session_wait shows a 'SQL*Net message from client' wait - the session seems to be doing nothing at all. This is the output from v$session_event for my latest try</P></FONT></P> <P><FONT size=2 úCE="Arial"><P>SID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EVENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOTAL_WAITS&nbsp; TOTAL_TIMEOUTS<BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; latch free&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am! ! ! p;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db file sequential read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0<BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb!</FONT></P> <P><FONT face=Arial size=2>!</FONT> <BR><FONT face=Arial size=2>!</FONT> <BR><FONT face=Arial size=2>sp;db file scattered read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a95&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 <BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; file open&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&! ! ! nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net message to client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $4859&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp; <BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net more data to client&nbsp;&nbsp;&nbsp; 9282&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp!</FONT></P> <P><FONT face=Arial size=2>!</FONT> <BR><FONT face=Arial size=2>!</FONT> <BR><FONT face=Arial size=2>;&nbsp;0&nbsp; <BR>63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQL*Net message from client&nbsp;&nbsp;244858&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR></P></FONT></P> <P><FONT face=Arial size=2><P>I'm running this on the server itself, so the network's not an issue. Tried different export modes and parameters (full, owner, tables, buffer, direct, etc.) but with the same result. I'm pretty new to this site, but I'm told that this problem's been there for some time now but was never really taken seriously&nbsp;since we don't take regular exports.</P></FONT></P> <P><FONT face=Arial size=2><P>I'm about to raise a TAR on this one, but any pointers before that would be useful.</P></FONT> <BR><FONT face=Arial size=2><P>TIA,</P></FONT> <BR><FONT face=Arial size=2><P>Mandar.</P></FONT> <BR><FONT face=Arial size=2><P>&nbsp;</P></FONT> <BR><FONT size=2 úCE="Arial"><P>&nbsp;</P></BLOCKQUOTE></FONT> <BR><FONT face=Arial size=2><hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at </font><a href="<A href="http://email.indiatimes.com/" target=_blank>http://email.indiatimes.com</A>"><font face="Arial" size="2"><A href="http://email.indiatimes.com/" target=_blank>http://email.indiatimes.com</A></font></a></b><br>Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from <A href="<A href="http://www.planetm.co.in/" target=_blank>http://www.planetm.co.in</A>"><A href="htt! ! ! p://www.planetm.co.in/" target=_blank>http://www.planetm.co.in</A></A></FONT></P> <P><FONT size=2 úCE="Arial">--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705--</FONT> </P> <P><FONT face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com/" target=_blank>http://www.orafaq.com</A></FONT> <BR><FONT face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Author: Mandar Shete</FONT> <BR><FONT face=Arial size=2> INET: [EMAIL PROTECTED]</FONT> </P> <P><FONT face=Arial size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) S8-5051</FONT> <BR><FONT face=Arial size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2 úCE="Arial">--------------------------------------------------------------------</FONT> <BR><FONT face=Arial size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT face=Arial size=2>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT face=Arial size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT face=Arial size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT face=Arial size=2>also send the HELP command for other information (like subscribing).</FONT> </P></UL></BLOCKQUOTE> <hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at </font><a href="http://email.indiatimes.com"><font face="Arial" size="2">http://email.indiatimes.com</font></a></b><br>Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from <A href="http://www.planetm.co.in">http://www.planetm.co.in</A> --=_MAILER_ATTACH_BOUNDARY1_2001102212023232124898138-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Shete INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).