Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Friday, June 25, 2010

Increase INI_TRANS for heavily logging tables

if the tables are transaction intensive like used for logging then increase ini_trans from default upto 4 or as you deem correct.

verify ini_trans using the below query
select table_name,ini_trans,freelists,freelist_groups from dba_tables
where owner='SIEBEL' AND TABLE_NAME IN
(
'S_DOCK_TXN_LOG')

No comments: