SQL Performance (MOSC)

MOSC Banner

Consistent gets is extremely high when schema not included in from clause

edited May 23, 2013 6:42AM in SQL Performance (MOSC) 11 commentsAnswered ✓
Hi,
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' );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center