Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Export Hanging

Re: Export Hanging

From: <Prasada.Gunda1_at_hartfordlife.com>
Date: Mon, 22 Oct 2001 10:36:40 -0700
Message-ID: <F001.003B1976.20011022105112@fatcity.com> 







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 doing
ALL_ROWS).


We recreated the view with RULE hint and export worked without any
problems.  I also did research in metalink and I found that the same
solution was given to similar questions by oracle tech support. If you have
access to metalink, please search with 'export hung' and you will get
related information.



hope this helps.


Prasad




                                                                                       
                                  
                    "Mandar Shete"                                                     
                                  
                    <mandar_shete_at_india        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>       
                    times.com>                 cc:                                     
                                  
                    Sent by:                   Subject:     Export Hanging             
                                  
                    root_at_fatcity.com                                                   
                                  
                                                                                       
                                  
                                                                                       
                                  
                    10/22/2001 09:50 AM                                                
                                  
                    Please respond to                                                  
                                  
                    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



<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;&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; 178&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; 6195&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; 244859&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; 149282&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: mandar_shete_at_indiatimes.com

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: ListGuru_at_fatcity.com (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: 
  INET: Prasada.Gunda1_at_hartfordlife.com

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: ListGuru_at_fatcity.com (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).


Received on Mon Oct 22 2001 - 12:36:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US