Re: Re: Export Hanging

2001-10-22 Thread Prasada . Gunda1


I did find it in SQLab (It is by Quest).  There was sql running for hours
on this table. Then, I did whatever I mentioned in my earlier mail.

Just to let you know, the table that we had problem wasn't the same table
other people reported in metalink.

Hope this helps.

Prasad




   
  
"Mandar Shete" 
  
   
times.com> cc: 
  
Sent by:   Subject:     Re: Re: Export Hanging 
  
[EMAIL PROTECTED]   
  
   
  
   
  
10/22/2001 03:22 PM
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




--=_MAILER_ATTACH_BOUNDARY1_2001102212345401867107722
Content-Type: text/plain; charset=us-ascii

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
why I can't see the session waiting on anything). If, as you said, the
session was hanging while trying to read a table, wouldn't I see at least
some db file reads ? In your case how did did you find that the session was
waiting on that particular event ?


Mandar.




[EMAIL PROTECTED] wrote:




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"

times.com> cc:
Sent by: Subject: Export Hanging
[EMAIL PROTECTED]


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



Hi All,





Oracle 8.1.6.1 N

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 why I can't see the session waiting on 
anything). If, as you said, the session was hanging while trying to read a table, 
wouldn't I see at least some db file reads ? In your case how did did you find that 
the session was waiting on that particular event ?


Mandar.




[EMAIL PROTECTED] wrote:




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" 

times.com> cc: 
Sent by: Subject: Export Hanging 
[EMAIL PROTECTED] 


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



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 
   &nb!
!
!
!
sp;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 client149282   
  !
!
!
!
; 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 
="Arial" size="2">http://email.indiatimes.com
Buy Music,
Video, CD-ROM, Audio-Books and Music Accessories from 
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 

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 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" 
  
   
times.com> cc: 
  
Sent by:   Subject: Export Hanging 
  
[EMAIL PROTECTED]   
  
   
  
   
  
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 free2
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 client149282  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


  TOTAL_WAITS  TOTAL_TIMEOUTS63 
    latch free   


 2

  263 db file
sequential read  
   178 
  063 
   &nb!
!
!
!
sp;db file scattered read
   6195 
0
63 file open 


    3 

 063   
  SQL*Net message to client  244859 
   
 0  63
SQL*Net m

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, 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 spellin

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 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 free2
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 client149282  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_TIMEOUTS63 latch
free
&nbs
p;  
2&nb
sp; 263  
   db file sequential
read
178&
nbsp;  063&nbs
p;   &nb!
!
!
sp;db file scattered
read
  
6195
 0
63 file
open
&nbs
p;   
3&nb
sp;
063 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  http://email.indiatimes.com";>http://email.indiatimes.comBuy
Music, Video, CD-ROM, Audio-Books and Music Accessories from 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
--

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 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 free2  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 client9282  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 




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             &! ! ! amp;nbsp;        2
63         db file sequential read             8                   0
63        &nb! ! ! sp;db file scattered read               a95                 0
63         file open                                 3                      0
63&a! ! ! mp;nbsp;        SQL*Net message to client      $4859             0 
63 &n


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 PROTECTED]]
Sent:   Monday, October 22, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L
Subject:    Export Hanging


--=_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  TOTAL_WAITS  TOTAL_TIMEOUTS63 latch free    2  263 db file sequential read 178   063&nb!

!
!
sp;db file scattered read   6195 0 63 file open 3  063 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">http://email.indiatimes.comBuy Music, Video, CD-ROM, Audio-Books and Music Accessories from 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).