create table t1 as select s1.nextval id,a.* from dba_objects a;
create table t2 as select s2.nextval id,a.* from dba_objects a;
insert into t1 select s1.nextval id,a.* from dba_objects a;
insert into t1 select s1.nextval id,a.* from dba_objects a;
insert into t2 select s2.nextval id,a.* from dba_objects a;
insert into t2 select s2.nextval id,a.* from dba_objects a;
insert into t2 select s2.nextval id,a.* from dba_objects a;
commit;

create index i1 on t1(id);
create index i2 on t2(id);
create index i11 on t1(object_type);

exec dbms_stats.gather_table_stats(user,'T1',cascade=>true);
exec dbms_stats.gather_table_stats(user,'T2',cascade=>true);

select count(*) from t1 where object_type='VIEW';

  COUNT(*)
----------
      8934

set autotrace traceonly explain

select * from t1,t2 where t1.id = t2.id and t1.object_type='VIEW' and t1.owner='SYS';

Execution Plan
----------------------------------------------------------
Plan hash value: 26873579

-------------------------------------------------------------------------------------
| Id  | Operation                    | Name | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT             |      |  1221 |   233K|   915   (1)| 00:00:11 |
|*  1 |  HASH JOIN                   |      |  1221 |   233K|   915   (1)| 00:00:11 |
|*  2 |   TABLE ACCESS BY INDEX ROWID| T1   |  1221 |   116K|   381   (1)| 00:00:05 |
|*  3 |    INDEX RANGE SCAN          | I11  |  8550 |       |    24   (0)| 00:00:01 |
|   4 |   TABLE ACCESS FULL          | T2   |   161K|    15M|   533   (1)| 00:00:07 |
-------------------------------------------------------------------------------------

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

   1 - access("T1"."ID"="T2"."ID")
   2 - filter("T1"."OWNER"='SYS')
   3 - access("T1"."OBJECT_TYPE"='VIEW')

data in table T1

ID	ONWER	OBJECT_TYPE
1	SYS	VIEW
2	ABC	PROCEDURE
3	SYS	PROCEDURE
4	ABC	PACKAGE
5	ABC	VIEW

the data in index I1

ID	ROWID
1	AABBCCDA
2	AABBCCDB
3	AABBCCDC
4	AABBCCDD
5	AABBCCDE

Step 1
	access index I1 
	get rowid for ID = 1 i.e. AABBCCDA
	access table T1 with rowid, AABBCCDA	-- This step gets us (1,'SYS',VIEW")
	apply filter (owner = 'SYS')
	Return data 
Iterate Step 1
	This time for ID=2
Iterate Step 1
	This time for ID=3
....so on

   loop	
		-- initiall i = 1 (i.e. ID = 1)
	access index I11
	get "all" rowids from block, in which for ID = i is stored
	--will it retrurn and use rowids for ID = 2,2,3 as well since it is in the same block
	access table T1 with -- this problem now as we have multiple rowids
	apply filter (owner = 'SYS')		** am I misunderstanding it?...will it apply filter row-by-row in loop
	Return data to hash table 
     i= i+1;
  end loop;

loop (on index structure)
  retrieve all rowid from current index block satifying the condition
  loop (on appropriate index block rowids)
    retrieve the row for one rowid, check if it satisfies the second condition -- [b]Filter application here? e.g. owner = 'SYS'?[/b]
    if yes pass the row to the next operation
  end loop
end loop

Case 1
************************
select * from t1;

Execution Plan
----------------------------------------------------------
Plan hash value: 838529891

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      |   120K|    11M|   394   (2)| 00:00:05 |
|   1 |  TABLE ACCESS FULL| T1   |   120K|    11M|   394   (2)| 00:00:05 |
--------------------------------------------------------------------------

Case 2
************************

select * from t1 where owner='SYS';

Execution Plan
----------------------------------------------------------
Plan hash value: 838529891

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      | 17257 |  1651K|   393   (1)| 00:00:05 |
|*  1 |  TABLE ACCESS FULL| T1   | 17257 |  1651K|   393   (1)| 00:00:05 |
--------------------------------------------------------------------------

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

   1 - filter("OWNER"='SYS')