SQL Performance (MOSC)

MOSC Banner

Statistics does not reflect execution plan

edited Mar 14, 2018 5:46AM in SQL Performance (MOSC) 6 commentsAnswered

Hi everyone,

Oracle database server 11.2.0.3 using ASM (grid 11.2.0.3)

The ORDER table has 17Millions records in it. If you look at the explain plan obtained in autotrace mode, and if my understanding of the cost is correct, it does not match the 4 consistent gets in the statistics. If I search in v$sql_plan I find the exact same plan. What is wrong in my interpretation?

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

optimizer_index_cost_adj             integer     100

db_file_multiblock_read_count        integer     128

var b1 VARCHAR2(4000)

var b2 NUMBER

var b3 NUMBER

var b4 NUMBER

var b5 NUMBER

var b6 VARCHAR2(2000)

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