3120809 - BI_PROCESS_DBSTAT performance issue

The BI_PROCESS_DBSTAT performance is running very slow.

By generating ST12 trace or checking AWR report, the slow SQL is 5scrj0dfb6a0w:

SELECT
  t.table_name, t.blocks, i.index_name, i.leaf_blocks, i.uniqueness
FROM
  user_tables t, user_indexes i
WHERE
  t.table_name = i.table_name and ( 1.1 * t.blocks ) < i.leaf_blocks and i.leaf_blocks > 1000 and
  i.blevel > 1 and t.partitioned = 'NO' and i.partitioned = 'NO' and i.status = 'VALID' and
  t.compression <> 'ENABLED' and ( t.table_name like :A0  or t.table_name like :A1  or t.table_name
  like :A2  ) and ( i.table_name like :A3  or i.table_name like :A4  or i.table_name like :A5  )
and ( i.index_name like :A6  or i.index_name like :A7  or i.index_name like :A8  )

BI_PROCESS_DBSTAT, performance, SQL patch , KBA , BC-DB-ORA , Oracle , Problem