Explain plan for customer
=================================
SQL> SELECT LPAD(' ',2*(LEVEL-1))||operation||' '||options ||' '||object_name
@       2  ||' '||DECODE(id, 0, 'Cost = '||position)
@       3  "Query Plan" FROM plan_table START WITH id = 0 AND statement_id =
@ 'xc'
@       4   CONNECT BY PRIOR id = parent_id
@       5  AND statement_id ='xc'
@       6   order by id;
@     SELECT STATEMENT   Cost = 10
@       NESTED LOOPS
@         NESTED LOOPS
@           NESTED LOOPS
@             NESTED LOOPS
@               NESTED LOOPS
@                 NESTED LOOPS
@                   NESTED LOOPS
@                     NESTED LOOPS
@                       NESTED LOOPS
@                         TABLE ACCESS BY INDEX ROWID FEM_XDIM_DIMENSIONS
@                           INDEX UNIQUE SCAN FEM_XDIM_DIMENSIONS_PK
@                         TABLE ACCESS BY INDEX ROWID FEM_DIMENSIONS_B
@                           INDEX UNIQUE SCAN FEM_DIMENSIONS_B_PK
@                       INDEX UNIQUE SCAN FEM_DIMENSIONS_TL_PK
@                     TABLE ACCESS BY INDEX ROWID FEM_COND_DIM_COMPONENTS
@                       INDEX UNIQUE SCAN FEM_COND_DIM_COMPONENTS_PK
@                   TABLE ACCESS BY INDEX ROWID FEM_DIMENSIONS_B
@                     INDEX UNIQUE SCAN FEM_DIMENSIONS_B_PK
@                 INDEX UNIQUE SCAN FEM_DIMENSIONS_TL_PK
@               TABLE ACCESS BY INDEX ROWID FEM_XDIM_DIMENSIONS
@                 INDEX UNIQUE SCAN FEM_XDIM_DIMENSIONS_PK
@             TABLE ACCESS BY INDEX ROWID FEM_COND_DIM_CMP_DTL
@               INDEX RANGE SCAN FEM_COND_DIM_CMP_DTL_PK
@           TABLE ACCESS BY INDEX ROWID FEM_CAL_PERIODS_B
@             INDEX UNIQUE SCAN FEM_CAL_PERIODS_B_PK
@         TABLE ACCESS BY INDEX ROWID FEM_DIM_ATTRIBUTES_B
@           INDEX UNIQUE SCAN FEM_DIM_ATTRIBUTES_B_UK1\

=============================================
Explain plan on our instance 

SELECT STATEMENT   Cost = 14
  NESTED LOOPS
    NESTED LOOPS
      NESTED LOOPS
        NESTED LOOPS SEMI
          NESTED LOOPS
            NESTED LOOPS
              NESTED LOOPS
                NESTED LOOPS
                  NESTED LOOPS
                    NESTED LOOPS
                      TABLE ACCESS BY INDEX ROWID FEM_XDIM_DIMENSIONS
                        INDEX UNIQUE SCAN FEM_XDIM_DIMENSIONS_PK
                      TABLE ACCESS BY INDEX ROWID FEM_DIMENSIONS_B
                        INDEX UNIQUE SCAN FEM_DIMENSIONS_B_PK
                    INDEX UNIQUE SCAN FEM_DIMENSIONS_TL_PK
                  TABLE ACCESS BY INDEX ROWID FEM_COND_DIM_COMPONENTS
                    INDEX UNIQUE SCAN FEM_COND_DIM_COMPONENTS_PK
                TABLE ACCESS BY INDEX ROWID FEM_DIMENSIONS_B
                  INDEX UNIQUE SCAN FEM_DIMENSIONS_B_PK
              INDEX UNIQUE SCAN FEM_DIMENSIONS_TL_PK
            TABLE ACCESS BY INDEX ROWID FEM_XDIM_DIMENSIONS
              INDEX UNIQUE SCAN FEM_XDIM_DIMENSIONS_PK
          TABLE ACCESS FULL FEM_DIM_ATTRIBUTES_B
        TABLE ACCESS BY INDEX ROWID FEM_COND_DIM_CMP_DTL
          INDEX RANGE SCAN FEM_COND_DIM_CMP_DTL_PK
      TABLE ACCESS BY INDEX ROWID FEM_DIM_ATTRIBUTES_B
        INDEX UNIQUE SCAN FEM_DIM_ATTRIBUTES_B_UK1
    TABLE ACCESS BY INDEX ROWID FEM_CAL_PERIODS_B
      INDEX UNIQUE SCAN FEM_CAL_PERIODS_B_PK

=======================================================