Re: hanged on import on undo segment

  • From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
  • To: jonathan@xxxxxxxxxxxxxxxxxx
  • Date: Wed, 23 Nov 2005 15:27:16 -0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: