SQL> explain plan set statement_id='STATEMENT_1' into plan_table for select * from obj where object_id = 1 or object_id=2 and owner='SYS';

Explained.

SQL> alter session set "_b_tree_bitmap_plans"=FALSE;

Session altered.

SQL> explain plan set statement_id='STATEMENT_2' into plan_table for select * from obj where object_id = 1 or object_id=2 and owner='SYS';

Explained.

SQL> set verify off
SQL> get a
  1  select lpad(' ',level-1) || operation || ' ' || options || ' ' || object_name "Plan"
  2  from plan_table
  3  connect by prior id = parent_id and prior statement_id = statement_id
  4* start with id = 0 and statement_id = '&1' order by id
SQL> @a
Enter value for 1: STATEMENT_1

Plan
--------------------------------------------------------------------------------
SELECT STATEMENT
 TABLE ACCESS BY INDEX ROWID OBJ
  BITMAP CONVERSION TO ROWIDS
   BITMAP OR
    BITMAP CONVERSION FROM ROWIDS
     INDEX RANGE SCAN PK_OBJ
    BITMAP CONVERSION FROM ROWIDS
     INDEX RANGE SCAN PK_OBJ

8 rows selected.

SQL> @a
Enter value for 1: STATEMENT_2

Plan
--------------------------------------------------------------------------------
SELECT STATEMENT
 CONCATENATION
  TABLE ACCESS BY INDEX ROWID OBJ
   INDEX UNIQUE SCAN PK_OBJ
  TABLE ACCESS BY INDEX ROWID OBJ
   INDEX UNIQUE SCAN PK_OBJ

6 rows selected.