Impact Of Increasing PCTFREE To 50 And INITRANS To 50
(Doc ID 2722452.1)
Last updated on MAY 03, 2023
Applies to:Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.
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:
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?
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