Here is the explan plain result:

explain plan for delete from dw.ACCOUNT_FACT                                         
        where rowid in
        (select rowid from DW.ACCOUNT_FACT
        minus
        select max(rowid) from DW.ACCOUNT_FACT
        group by CRTORD_FIPS_CD, LAST_PAYMENT_DT, ORDER_NUM, ACCOUNT_TYP_ID, MEMBER_ID, CASE_NUM, MONTHLY_SOA_AMT, ACCOUNT_CLOSED_DT, ACCOUNT_CREATION_DT, SOA_FREQ_CD, FED_TAX_CERT_IND, ACCOUNT_BALANCE_AMT, STATE_TAX_CERT_CD, ACCOUNT_BALANCE_UPDATE_DT, ACCOUNT_STATUS_CD);
commit;

select * from table(dbms_xplan.display);


PLAN_TABLE_OUTPUT

Plan hash value: 611392786
 
----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                          | Name                    | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------------------------
|   0 | DELETE STATEMENT                   |                         |  2604G|   260T|       |  9018K (91)| 30:03:37 |
|   1 |  DELETE                            | ACCOUNT_FACT            |       |       |       |            |          |
|*  2 |   HASH JOIN                        |                         |  2604G|   260T|   369M|  9018K (91)| 30:03:37 |
|   3 |    VIEW                            | VW_NSO_1                |    16M|   184M|       |   745K  (1)| 02:29:12 |
|   4 |     MINUS                          |                         |       |       |       |            |          |
|   5 |      SORT UNIQUE                   |                         |    16M|   184M|   309M|            |          |
|   6 |       BITMAP CONVERSION TO ROWIDS  |                         |    16M|   184M|       |    20   (0)| 00:00:01 |
|   7 |        BITMAP INDEX FULL SCAN      | IDX_AC_FED_TAX_CERT_IND |       |       |       |            |          |
|   8 |      SORT UNIQUE                   |                         |    16M|  1354M|  1939M|            |          |
|   9 |       SORT GROUP BY                |                         |    16M|  1354M|  1939M|   672K  (1)| 02:14:27 |
|  10 |        TABLE ACCESS BY INDEX ROWID | ACCOUNT_FACT            |    16M|  1354M|       | 18923   (3)| 00:03:48 |
|  11 |         BITMAP CONVERSION TO ROWIDS|                         |       |       |       |            |          |
|  12 |          BITMAP INDEX FULL SCAN    | IDX_AC_FED_TAX_CERT_IND |       |       |       |            |          |
|  13 |    TABLE ACCESS BY INDEX ROWID     | ACCOUNT_FACT            |    16M|  1508M|       |    20   (0)| 00:00:01 |
|  14 |     BITMAP CONVERSION TO ROWIDS    |                         |       |       |       |            |          |
|  15 |      BITMAP INDEX FULL SCAN        | IDX_AC_FED_TAX_CERT_IND |       |       |       |            |          |
----------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - access(ROWID="$kkqu_col_1")

I have all constraints disabled. How do I make this delete finish faster? We're trying to remove duplicates from this table using the criteria giving in the statement.

Thanks