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: hanged on import on undo segment

Re: hanged on import on undo segment

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 23 Nov 2005 19:47:46 -0000
Message-ID: <023101c5f066$c8d83470$6902a8c0@Primary>

Which SID is your import ?

Look at the program names in v$session to find out, and then use Tom Kyte's print_table routine to print up the single row from v$session_wait that might be relevant.

How do you know that you are "hanging" - if you've done an import that needs to create a lot of indexes and it's doing it on parallel-enabled tables, maybe the display has stopped but the machine is busy.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 4th Nov 2005

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 4th Nov 2005

Thanks Jhonatan,
Even when the import is hanged several hours, I didn't find a specific wait event, or I'm querying the wrong t able. select * from V$SESSION_WAIT order by seconds_in_wait desc

       10 325 SQL*Net message from client driver id
1.414E+09 54435000
#bytes

  1 00000001

  0 00               0
          17101 WAITING

       19       325 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
          17101 WAITING

       14       325 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
          17101 WAITING

       11     34903 SQL*Net message from dblink
driver id
675562835 28444553
#bytes

  1 00000001
  0 00               0
          17097 WAITING

       26        25 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
          11791 WAITING

       30        18 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
          11769 WAITING

       27        18 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
          11769 WAITING

       25        18 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
          11652 WAITING

       21        16 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
           7041 WAITING

       20       725 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
           7015 WAITING

        6        19 rdbms ipc message

timeout
180000 0002BF20
                                                                         0 
00
  0 00               0
            544 WAITING

        9      3228 rdbms ipc message

timeout
30000 00007530
                                                                         0 
00
  0 00               0
            294 WAITING

        5       280 smon timer

sleep time
300 0000012C
failed                                                                   0 
00
  0 00               0
            270 WAITING

       22       350 SQL*Net message from client
driver id
1.414E+09 54435000
#bytes

  1 00000001
  0 00               0
            185 WAITING

        8      5666 rdbms ipc message

timeout
6000 00001770
                                                                         0 
00
  0 00               0
             43 WAITING

       18        70 null event

1.414E+09 54435000

  1 00000001

  0 00              -1
              0 WAITED KNOWN TIME

        7      4194 rdbms ipc message

timeout
500 000001F4
                                                                         0 
00
  0 00               0
              0 WAITING

       31      4180 library cache lock

handle address
291879320 1165B998
lock address
296691392 11AF26C0
100*mode+namespace
201 000000C9         0
              0 WAITING

       16      6090 library cache lock

handle address
291879320 1165B998
lock address
296769524 11B057F4
100*mode+namespace
201 000000C9         0
              0 WAITING

        4     14294 rdbms ipc message

timeout
300 0000012C
                                                                         0 
00
  0 00               0
              0 WAITING

        1      7118 pmon timer

duration
300 0000012C
                                                                         0 
00
  0 00               0
              0 WAITING

        2     16303 rdbms ipc message

timeout
300 0000012C
                                                                         0 
00
  0 00               0
              0 WAITING

        3      7592 rdbms ipc message

timeout
300 0000012C
                                                                         0 
00
  0 00               0
              0 WAITING
--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 23 2005 - 13:49:55 CST

Original text of this message

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