TUNNING SQL VERY SLOW(table 1200 millons rows)

We have a select very slow . In this sql we have a view about a table (1200millons rows).

SQL ID: 3gws0hxw37fza Plan Hash: 3734131871

select all dm_federation.r_object_id, dm_federation.r_govern_docbase

from

S000495.dm_federation_sp dm_federation where ((dm_federation.object_name=

  :"SYS_B_0")) and (dm_federation.i_has_folder = :"SYS_B_1" and

  dm_federation.i_is_deleted = :"SYS_B_2")

call     count       cpu    elapsed       disk      query    current        rows

------- ------  -------- ---------- ---------- ---------- ----------  ----------

Parse        2      0.00       0.00          0          0          0           0

Execute      2      0.00       0.01          0          0          0           0

Fetch        1    173.32    8611.24    3578664    3581287          0           0

------- ------  -------- ---------- ---------- ---------- ----------  ----------

total        5    173.32    8611.25    3578664    3581287          0           0

Misses in library cache during parse: 1