expensive SQL

Greetings

I see the following SQL from the Developer,

select * from max_update where rowid in
(select max(rowid) from vrcdba.max_update group by request_id ) and request_id not in (select request_id from max_update where server ='cas1');

Takes for ever

What is he tryig to to do

Appreciate your help

Regards & thanks

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