1460440.1 PXHCDR 11.4.5.8 Report: pxhcdr_orcl_rac1_11.2.0.4.0_20180125_164346_dop.html

License   : N
RDBMS     : 11.2.0.4.0
Platform  : LINUX
Instance  : 1
CPU Count : 4
Block Size: 8192
OFE       : 11.2.0.4
DYN_SAMP  : 2
EBS       : ""
SIEBEL    : ""
PSFT      : ""
Date      : 2018-01-25/16:43:46

Tables with non-default DOP

Collected from DBA_TABLES where degree != 1.
# Owner Table DOP Inst Blocks MB GB Part Temp
# Owner Table DOP Inst Blocks MB GB Part Temp

Tables and Indexes with DOP mismatch

Collected from DBA_TABLES and DBA_INDEXES where t.degree != i.degree.
# Owner Table DOP Inst Blocks MB GB Part Temp Index Type DOP Inst Leaf
Blocks
MB GB Part
# Owner Table DOP Inst Blocks MB GB Part Temp Index Type DOP Inst Leaf
Blocks
MB GB Part

1460440.1 PXHCDR 11.4.5.8 2018-01-25/16:43:46