溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
In earlier releases, the MAXTRANS parameter determined the maximum number of concurrent update transactions allowed for each data block in the segment. This parameter has been deprecated. Oracle now automatically allows up to 255 concurrent update transactions for any data block, depending on the available space in the block.
Existing objects for which a value of MAXTRANS has already been set retain that setting. However, if you attempt to change the value for MAXTRANS, Oracle ignores the new specification and substitutes the value 255 without returning an error.
對于ini_trans, max_trans的默認值，表級為1,索引級為2. 一般來說不需要做特別的設置。可以根據業務的需要來配置。
以下設置可供參考：
對于大表，數據千萬級以上的表，initrans建議設置為8~16
對于中級表，數據量在百萬到千萬級，initrans建議設置為4~8
對于普通的表，initrans建議設置為1~4
對于此等待事件，解決思路有三種：
1) Depending on the number of transactions in the table we need to alter the value of INITRANS.
If the issue is not resolved by increasing INITRANS then try increasing PCTFREE. Increasing PCTFREE holds more
1) Spreading rows into more number of blocks will also helps to reduce this wait event.
2) Then re-organize the table using move (alter table service_T move;)
3) Rebuild index
Increase INITRANS
here it has been changed to 50:
alter table INITRANS 50;
2) Then re-organize the table using move (alter table move;)
3) Then rebuild all the indexes of this table as below
alter index rebuild INITRANS 50;
Increase PCTFREE
space back and so spreads the same number of rows over more blocks. This means that there are more ITL slots
available overall :
alter table PCTFREE 40;
alter index index_name rebuild PCTFREE 40;
A Combination of increasing both INITRANS and PCTFREE
1) Set INITRANS to 50 pct_free to 40
alter table PCTFREE 40 INITRANS 50;
2) Re-organize the table using move (alter table move;)
3) Then rebuild all the indexes of the table as below
alter index rebuild PCTFREE 40 INITRANS 50;
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
