Query performance issue (need help)

 Hi, Since I've upgraded from Oracle 9.2.0.8 to 10.2.0.4 on a production database, i've a performance issue on a query that take more than 8hours to execute.

Can someone give me a help.

Please find the query test and the explain plan :

SQL> r
  1  select all lp_dca_ds_dec.r_object_id, lp_dca_ds_dec.object_name,
  2           lp_dca_ds_dec.r_object_type, lp_dca_ds_dec.r_lock_owner,
  3           lp_dca_ds_dec.owner_name, lp_dca_ds_dec.r_link_cnt,
  4           lp_dca_ds_dec.r_is_virtual_doc, lp_dca_ds_dec.r_content_size,
  5           lp_dca_ds_dec.a_content_type, lp_dca_ds_dec.i_is_reference,