Re: hanged on import on undo segment


No. The session is waiting if the state is 'WAITING'.

The 'wait_time = 0' thing was true in earlier versions of Oracle but got broken in v9 when the timings changed
to microseconds and the decodes weren't brought up
to date.

The problem has been fixed, but I don't know which version of 9 fixed it - so as a guideline, don't look in the wrong place in case you get the wrong answer.

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

----- Original Message ----- From: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
To: <juancarlosreyesp@xxxxxxxxx>; <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, November 23, 2005 7:32 PM
Subject: 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 




--
http://www.freelists.org/webpage/oracle-l


Other related posts: