seg$ doesn't need an initrans setting, it's part of a cluster (c_file#_block#)
and the cluster initrans dictates the minimum number of concurrent transactions
per block.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Bajwa, Sandeep [ssb14@xxxxxxxx]
Sent: 10 November 2015 16:20
To: niall.litchfield@xxxxxxxxx; howard.latham@xxxxxxxxx
Cc: ORACLE-L
Subject: Why SEG$ table has 0 ini_trans
Does this oracle internal table needs to have 0 as a Ini_Trans?
SQL> select table_name,ini_trans from dba_tables
2 where table_name in (select object_name from v$segment_statistics where
upper(statistic_name) like '%ITL%' and value > 0)
3 /
TABLE_NAME INI_TRANS
------------------------------ ----------
SEG$ 0
Thanks,
Sandeep
