| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes
Pacheco
Sent: Wednesday, November 23, 2005 11:27 AM
To: jonathan_at_jlcomp.demon.co.uk
Cc: oracle-l_at_freelists.org
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
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-lReceived on Wed Nov 23 2005 - 13:35:20 CST
 |
 |