Heavy DML : Table Parameters for Optimizing Performance
845811Sep 25 2012 — edited Sep 26 2012Hello All,
ENV : Oracle 11g R2
Single Node Instance
I would like to know what are the optimal parameters for Initrans, Maxtrans etc ( any other parameters ) that we can use for Insert / DML Intensive tables.
For Eg : I have a table that has around 50-70 k records being inserted every 1-2 minutes.
Is there any table parameters that I can change ( this table as required Index, Locally partitioned).
In the same way if it is a merge intensive table , are there any parameters that we can set to help improve performance?
I am just trying to gather feedback on any table parameters that we can set pro actively to help performance for DML Intensive large tables.
Thanks in advance