create table test_bm 
as 
select rownum id
   , trunc(dbms_random.value( 100 , 210 + 1 )) height 
   , trunc(dbms_random.value( 16 , 100 + 1 )) age 
from dual 
connect  by level <= 100000 ;

create bitmap index tesT_bm#height on test_bm(height);
create bitmap index tesT_bm#age on test_bm(age);

explain plan for
select * 
from tesT_bm 
where height between  165  and  175  or age between  18  and  25  and age !=  22 ;

select * from table(dbms_xplan.display());

Plan hash value:  1289150775 
 
-----------------------------------------------------------------------------------------------
| Id  | Operation                    | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------------------
|    0  | SELECT STATEMENT             |                |  16978  |   646K|     29    ( 0 )|  00 : 00 : 01  |
|    1  |  TABLE ACCESS BY INDEX ROWID | TEST_BM        |  16978  |   646K|     29    ( 0 )|  00 : 00 : 01  |
|    2  |   BITMAP CONVERSION TO ROWIDS|                |       |       |            |          |
|    3  |    BITMAP OR                 |                |       |       |            |          |
|    4  |     BITMAP MERGE             |                |       |       |            |          |
|*   5  |      BITMAP INDEX RANGE SCAN | TEST_BM#HEIGHT |       |       |            |          |
|    6  |     BITMAP MERGE             |                |       |       |            |          |
|*   7  |      BITMAP INDEX RANGE SCAN | TEST_BM#AGE    |       |       |            |          |
-----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
    5  - access("HEIGHT">= 165  AND "HEIGHT"<= 175 )
    7  - access("AGE">= 18  AND "AGE"<= 25 )
       filter("AGE"<> 22 )
 
Note
-----
   - dynamic sampling used for this statement (level= 2 )