SQL Performance (MOSC)

MOSC Banner

What is meaning of SSZ in 10053 trace on 12.2

edited Apr 19, 2019 12:24PM in SQL Performance (MOSC) 4 commentsAnswered
select count(*) from tab1;***************************************BASE STATISTICAL INFORMATION***********************Table Stats::  Table: TAB1  Alias: TAB1  (Using composite stats)  #Rows: 41126836  SSZ: 0  LGR: 0  #Blks:  0  AvgRowLen:  792.00  NEB: 0  ChainCnt:  0.00  ScanRate:  0.00  SPC: 0  RFL: 0  RNF: 0  CBK: 0  CHR: 0  KQDFLG: 1select count(*) from tab1 partition(p10);***************************************BASE STATISTICAL INFORMATION***********************Table Stats::  Table: TAB1  Alias: TAB1  Partition [10]  #Rows: 20480777  SSZ: 20480777  LGR: 0  #Blks:  2406080  AvgRowLen:  788.00  NEB: 0  ChainCnt:  0.00  ScanRate:  0.00  SPC: 0  RFL: 0  RNF: 0  CBK: 0  CHR: 0  KQDFLG: 1

Cannot find any help on SSZ?

Also, why is the SQL in partition giving the right number of blocks vs the one against the full table says #Blks: 0

Thanks,

Vikram 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