SAP Knowledge Base Article - Preview

3120809 - BI_PROCESS_DBSTAT performance issue

Symptom

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  )


Read more...

Product

SAP NetWeaver 7.5

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.