RE: hanged on import on undo segment

Juan, I think that's the correct view.

But remember the wait event is only active (that being the current wait
event) if the WAIT_TIME column is 0 


Thanks! 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Juan Carlos Reyes
Pacheco
Sent: Wednesday, November 23, 2005 11:27 AM
To: jonathan@xxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: hanged on import on undo segment

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


Other related posts: