My Oracle Support Banner

Impact of changing Blevel 3 Metrics for Indexes In Siebel Database (Doc ID 2784497.1)

Last updated on JUNE 16, 2021

Applies to:

Siebel Communications, Media and Energy CRM - Version 8.1.1.11.17 [IP2013] and later
Information in this document applies to any platform.

Goal

There are multiple indexes in Siebel database for which Blevel status is 3. As per DBA recommendation it is advised to set status 0 or 1 by rebuilding the indexes.

Below are the few examples of status 3 indexes

Metric:BLEVEL
Metric value=3

Table_Name Index_Name
S_ORG_BU S_ORG_BU_M50
S_ORG_BU S_ORG_BU_M51
S_ORG_BU S_ORG_BU_M3
S_ORG_BU S_ORG_BU_M2
S_ALERT_CUT S_ALERT_CUT_INT_ID

Is it recommended to change Blevel Metrics to 0 or 1 and will there be any impact if changed.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.