My Oracle Support Banner

Impact Of Increasing PCTFREE To 50 And INITRANS To 50 (Doc ID 2722452.1)

Last updated on OCTOBER 27, 2020

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Goal

During Performance testing it was observed that there are lot of index contention and cluster waits are happening for 5-6 tables.

There was recommendation to increase PCTFREE and INITRANS for following tables:

S_EVT_ACT

S_EVT_ACT_FSX

S_EVT_ACT_FNX

S_SUSP_ACT

S_EVT_MKTG

S_EVT_ACT_CAL

By default siebel generates index with PCTFREE 10 and INITRANS 2.

Q1. Will there be any other impact of increasing PCTFREE to 50 and INITRANS to 50? Is it recommended?

Q2. What will happen during DDL sync when we create new indexes? Do we need to increase it every time after DDL Sync?

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.