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_at_weyerhaeuser.com> To: <juancarlosreyesp_at_gmail.com>; <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org> 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 Received on Wed Nov 23 2005 - 13:43:32 CST