Why not just query directly from DBA_TABLES for the ini_trans value?
select table_name, ini_trans
from dba_tables
where ini_trans = 0
and owner = ‘SYS’
order by 1
On a 10.2.0.5 EE system this returned 65 tables and 82 on an 11.2.0.3 Standard
Ed system. You would need to dump the header block to see if Oracle allocated
a default number of ITL’s in the block.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bajwa, Sandeep
Sent: Tuesday, November 10, 2015 11:21 AM
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
