orclz> select * from table(dbms_xplan.display_cursor(format=>'allstats last'));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------
SQL_ID  89kpxk66s0nm2, child number 0
-------------------------------------
SELECT /*+ no_query_transformation */ * FROM EMP A WHERE NOT EXISTS
(SELECT 1 FROM EMP_INACTIVE WHERE EMPID = A.ID) AND NOT EXISTS (SELECT
1 FROM EMP_TRANSFERRED WHERE EMPID = A.ID) AND ID IN (105)

Plan hash value: 2374400023

-----------------------------------------------------------------------------------------------------------------
| Id  | Operation                    | Name                   | Starts | E-Rows | A-Rows |   A-Time   | Buffers |
-----------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT             |                        |      1 |        |      0 |00:00:00.01 |       3 |
|*  1 |  FILTER                      |                        |      1 |        |      0 |00:00:00.01 |       3 |
|   2 |   TABLE ACCESS BY INDEX ROWID| EMP                    |      1 |      1 |      1 |00:00:00.01 |       2 |
|*  3 |    INDEX UNIQUE SCAN         | MY_EMP_ID_PK           |      1 |      1 |      1 |00:00:00.01 |       1 |
|*  4 |   INDEX RANGE SCAN           | EMP_INACTIVE_INDX01    |      1 |      1 |      1 |00:00:00.01 |       1 |
|*  5 |   INDEX RANGE SCAN           | EMP_TRANSFERRED_INDX01 |      0 |      1 |      0 |00:00:00.01 |       0 |
-----------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(( IS NULL AND  IS NULL))
   3 - access("ID"=105)
   4 - access("EMPID"=:B1)
   5 - access("EMPID"=:B1)


27 rows selected.

orclz>