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, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, October 22, 2001 8: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 178 0 63 db file scattered read 6195 0 63 file open 3 0 63 SQL*Net message to client 244859 0 63 SQL*Net more data to client 149282 0 63 SQL*Net message from client 244858 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 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 ; &nb sp; TOTAL_WAITS TOTAL_TIMEOUTS 63 latch free &nbs p; 2 &nb sp; 2 63 db file sequential read 178 & nbsp; 0 63 &nbs p; &nb! ! ! sp;db file scattered read 6195 0 63 file open &nbs p; 3 &nb sp; 0 63 SQL*Net message to client 244859 &nbs p; 0 63 SQL*Net more data to client 149282 &nbs p; ! ! ! ; 0 63 SQL*Net message from client 244858 &nbs p; 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 face="Arial" size="2">http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from href="http://www.planetm.co.in">http://www.planetm.co.in --=_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) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). 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_20011022122322570073850 Content-Type: text/html; charset=us-ascii <P>Thanks Denis - I should have mentioned it - nothing in the alert log either.</P> <P>Mandar.<BR><BR><B><I>[EMAIL PROTECTED]</B></I> wrote:<BR><BR></P> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>Mandar - Have you checked you alert log to see if Oracle is writing anything<BR>useful there? Maybe you have, I just didn't see where you mentioned it.<BR>Dennis Williams<BR>DBA<BR>Lifetouch, Inc.<BR>[EMAIL PROTECTED]<BR><BR><BR>-----Original Message-----<BR>Sent: Monday, October 22, 2001 8:50 AM<BR>To: Multiple recipients of list ORACLE-L<BR><BR><BR>--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705<BR>Content-Type: text/plain; charset=us-ascii<BR><BR><BR>Hi All,<BR><BR><BR><BR>Oracle 8.1.6.1 NT 4 SP5<BR><BR><BR>I'm facing a problem with all exports hanging on our production database.<BR>Tried it several times, but the export seems to get stuck at different<BR>points each time. The strange part is that at this point v$session_event<BR>shows absolutely nothing happening - all the wait numbers just freeze<BR>indefinitely and v$session_wait shows a 'SQL*Net message from client' wa! ! ! it -<BR>the session seems to be doing nothing at all. This is the output from<BR>v$session_event for my latest try<BR><BR><BR>SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS<BR>63 latch free 2<BR>2<BR>63 db file sequential read 178 0<BR>63 db file scattered read 6195 0 <BR>63 file open 3<BR>0<BR>63 SQL*Net message to client 244859 0 <BR>63 SQL*Net more data to client 149282 0 <BR>63 SQL*Net message from client 244858 0<BR><BR><BR><BR>I'm running this on the server itself, so the network's not an issue. Tried<BR>different export modes and parameters (full, owner, tables, buffer, direct,<BR>etc.) but with the same result. I'm pretty new to this site, but I'm told<BR>that this problem's been there for some time now but was never really taken<BR>seriously since we don't take regular exports.<BR><BR><BR>I'm about to raise a TAR on this one, but any pointers before that would be<BR>useful.<BR><BR><BR>TIA,<BR><BR><BR>Mandar.<BR><BR><BR><BR><BR><BR><BR>Get Your Private, Free E-mail from Indiatim! ! ! es at<BR>http://email.indiatimes.com<BR>Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from<BR>http://www.planetm.co.in<BR><BR>--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705<BR>Content-Type: text/html; charset=us-ascii<BR><BR><BR><BR>Hi All,<BR> <BLOCKQUOTE style="MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; br: 5px"><BR> <P>Oracle 8.1.6.1 NT 4 SP5</P><BR> <P>I'm facing a problem with all exports hanging on our production database.<BR>Tried it several times, but the export seems to get stuck at different<BR>points each time. The strange part is that at this point v$session_event<BR>shows absolutely nothing happening - all the wait numbers just freeze<BR>indefinitely and v$session_wait shows a 'SQL*Net message from client' wait -<BR>the session seems to be doing nothing at all. This is the output from<BR>v$session_event for my latest try</P><BR> <P>SID <BR>EVENT <BR>; &nb<BR>sp; TOTAL_WAITS <BR>TOTAL_TIMEOUTS<BR>63 latch<BR>free <BR> &nbs<BR>p; <BR>2 &nb<BR>sp; 2<BR>63 <BR> db file sequential<BR>read <BR>178 &<BR>nbsp; &! ! ! nbsp;0<BR>63 &nbs<BR>p; &nb!<BR>!<BR>!<BR>sp;db file scattered<BR>read <BR> <BR>6195 <BR> 0<BR><BR>63 file<BR>open <BR> &nbs<BR>p; <BR>3 &nb<BR>sp; <BR>0<BR>63 SQL*Net message to<BR>client <BR>244859 &nbs<BR>p; 0 <BR>63 &nbs! ! ! p; <BR>SQL*Net more data to client <BR>149282 &nbs<BR>p; !<BR>!<BR>!<BR>; 0 <BR><BR>63 SQL*Net message<BR>from<BR>client 244858 &nbs<BR>p; 0<BR></P><BR> <P>I'm running this on the server itself, so the network's not an issue.<BR>Tried different export modes and parameters (full, owner, tables, buffer,<BR>direct, etc.) but with the same result. I'm pretty new to this site, but I'm<BR>told that this problem's been there for some time now but was never really<BR>taken seriously since we don't take regular exports.</P><BR> <P>I'm about to raise a TAR on this one, but any pointers before that would<BR>be useful.</P><BR> <P>TIA,</P><BR> <P>Mandar.</P><BR> <P> </P><BR> <P> </P></BLOCKQUOTE><BR> <HR> <FONT face=Arial size=2><B>Get Your Private, Free E-mail from<BR>Indiatimes at </FONT><A href="http://email.indiatimes.com/"><FONT<BR>face="Arial" size="2">http://email.indiatimes.com</FONT></A></B><BR>Buy<BR>Music, Video, CD-ROM, Audio-Books and Music Accessories from <A<BR>href="http://www.planetm.co.in">http://www.planetm.co.in</A><BR><BR>--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705--<BR><BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>-- <BR>Author: Mandar Shete<BR>INET: [EMAIL PROTECTED]<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list! ! ! you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>-- <BR>Author: DENNIS WILLIAMS<BR>INET: [EMAIL PROTECTED]<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><BR> <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_20011022122322570073850-- -- 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).