Check DB Job taking very long time

[Former Member]

Hi All,

I have BI system SAP EHP 1 for SAP NetWeaver 7.0 with SP level as

SAP_ABA 701 SAPKA70105

SAP_BASIS 701 SAPKB70105

Kernel is 152 and DBSL patch is 148

Database is Oracle 10.2.0.4.0.

Database size is 4.6 TB and checkdb job is taking approx 9-10 hrs to complete. Even if size of database is big CHECKDB should not take this much time to complete.

Every time we have to cancel this job as it impacts system performance.

There are enough background work process available in system.

Please provide any inputs if it can be helpful.

Regards

Vinay

[Former Member]

Hi Vinay,

In order to avoid this unexpected behavior, you need to use the latest BR*Tools and as well as update / adjust individual statistic values, excludes the relevant tables from the statistics creation using the BRCONNECT tool (ACTIV=I in DBSTATC) and also locks the statistics at Oracle level (DBMS_STATS.LOCK_TABLE_STATS).

BR*Tools 7.10 are used with Oracle 10g by default. This is also a prerequisite for most of the new features.

We need to have a plan for the following.

1. Update the brtools version from 7.00 (40) to 7.10 (41) [ Latest available in SMP ] or to 7.20 (16) [ Exceptions with Non-ABAP Systems ]

2. Execute the script attached to Note 1020260 - Delivery of Oracle statistics (Oracle 10g, 11g)

Br,

Venky.