question on initrans
From: Pap <oracle.developer35_at_gmail.com>
Date: Tue, 11 May 2021 22:17:15 +0530
Message-ID: <CAEjw_fi7s61bqos0a8kmakXiQEjfq-3+hntAg6aiENBsnmDBUw_at_mail.gmail.com>
This database was recently moved from HP to exadata X7 and the DB version also migrated from 11.2.0.4 to 19.9.0.0.0. It's an OLTP database. In the past we saw some contention and got a recommendation from Oracle to set INITRANS value of certain objects(both table and indexes) to as high as 50. And now the team is thinking to set the initrans value to ~10 for almost all the objects(~around ~200+ objects). Want to understand , what is the negative side of setting it to this non default value considering this is an OLTP database exposed to many concurrent DML/query and we encounter "buffer busy waits" many times?
Date: Tue, 11 May 2021 22:17:15 +0530
Message-ID: <CAEjw_fi7s61bqos0a8kmakXiQEjfq-3+hntAg6aiENBsnmDBUw_at_mail.gmail.com>
This database was recently moved from HP to exadata X7 and the DB version also migrated from 11.2.0.4 to 19.9.0.0.0. It's an OLTP database. In the past we saw some contention and got a recommendation from Oracle to set INITRANS value of certain objects(both table and indexes) to as high as 50. And now the team is thinking to set the initrans value to ~10 for almost all the objects(~around ~200+ objects). Want to understand , what is the negative side of setting it to this non default value considering this is an OLTP database exposed to many concurrent DML/query and we encounter "buffer busy waits" many times?
Regards
Pap
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 11 2021 - 18:47:15 CEST