Troubleshooting waits for enq TX - allocate ITL entry - Document 1472175.1

1) Set INITRANS to 50 and pct_free to 40
alter table <table_name> INITRANS 50;
alter table <table_name> PCTFREE 40 INITRANS 50;
2) Re-organize the table using move (alter table <table_name> move;)
alter table <table_name> move;
3) Then rebuild all the indexes of the table as below
alter index <index_name> rebuild INITRANS 50;
alter index <index_name> rebuild online PCTFREE 20;
alter index <index_name> rebuild PCTFREE 40 INITRANS 50;
alter index <index_name> rebuild online PCTFREE 20 INITRANS 50;

ALTER TABLE ORGANIZATION PCTFREE 20 INITRANS 16;
ALTER TABLE ORGANIZATION MOVE;
ALTER INDEX PK_ORGANIZATION REBUILD PCTFREE 20 INITRANS 16 NOLOGGING;


ALTER TABLE TLHR.TLHRBOKBAL PCTFREE 20 INITRANS 16 ;
ALTER TABLE TLHR.TLHRBOKBAL MOVE NOLOGGING PARALLEL 12;
ALTER TABLE TLHR.TLHRBOKBAL LOGGING NOPARALLEL;
ALTER INDEX TLHR.PK_TLHRBOKBAL REBUILD PCTFREE 20 INITRANS 16 NOLOGGING PARALLEL 12;
ALTER INDEX TLHR.PK_TLHRBOKBAL LOGGING NOPARALLEL;