Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INITRANS question.

KunwarApr 5 2014 — edited Apr 6 2014

hi Friends,

Recently i faced few issues ("enq: TX - allocate ITL entry" waits on a table) due to which i had to increase INITRANS of the tables/indexes in question. Earlier it was default value.

In coming days i will be creating DBs for the similar implementation. I am thinking of keeping the INITRANS of all the application tables/indexes to 32.

Do you see any disadvantages with keeping all objects' INITRANS to 32 instead of default?

I don't want to wait for the application testing to commence there and later i have to increase INITRANS.

Thanks,

Kunwar

This post has been answered by unknown-7404 on Apr 5 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2014

Added on Apr 5 2014

#general-database-discussions

6 comments

1,589 views