create table test_tab
as
select round(dbms_random.value(1, 100000)) as f1,
       round(dbms_random.value(1, 100)) as f2,
       round(dbms_random.value(1, 100)) as f3,       
       round(dbms_random.value(1, 100)) as f4       
  from dual connect by level < 3000001;
  
create table test_tab2 as select t.*, ROWNUM AS f5 from test_tab t where rownum < 1000001;
create index test_tab2_i on test_tab2(f5);

create table test_tab3 as select t.*, ROWNUM AS f5 from test_tab t where rownum < 1000001;
create index test_tab3_i on test_tab3(f5);

select /*+ no_parallel*/ t1.*, t2.f5, t3.f5
  from test_tab t1,
       test_tab2 t2,
       test_tab3 t3
 where t1.f1 = t2.f5(+)
   and t1.f1 = t3.f5(+);

-----------------------------------------------------------------------------------------
| Id  | Operation                | Name        | Rows    | Bytes     | Cost  | Time     |
-----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT         |             | 3100371 | 241828938 | 23546 | 00:04:43 |
| * 1 |   HASH JOIN RIGHT OUTER  |             | 3100371 | 241828938 | 23546 | 00:04:43 |
|   2 |    INDEX FAST FULL SCAN  | TEST_TAB3_I |  824834 |  10722842 |   624 | 00:00:08 |
| * 3 |    HASH JOIN RIGHT OUTER |             | 3100370 | 201524050 | 11911 | 00:02:23 |
|   4 |     INDEX FAST FULL SCAN | TEST_TAB2_I |  824834 |  10722842 |   624 | 00:00:08 |
|   5 |     TABLE ACCESS FULL    | TEST_TAB    | 3100368 | 161219136 |  1980 | 00:00:24 |
-----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
------------------------------------------
* 1 - access("T1"."F1"="T3"."F5"(+))
* 3 - access("T1"."F1"="T2"."F5"(+))