Consistent gets is extremely high when schema not included in from clause
Using version 11.2.0.3 on Solaris 10.
We run a query that does not include the schema name in the from clause.
SELECT count(*) FROM call_req WHERE ( call_req.active_flag = 1 ) AND ( call_req.type = N'R' );
Elapsed: 00:00:10.88
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
434406 consistent gets
0 physical reads
116 redo size
209 bytes sent via SQL*Net to client
252 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
We run the same query but include the schema
SELECT count(*) FROM mdbadmin.call_req WHERE ( call_req.active_flag = 1 ) AND ( call_req.type = N'R' );