Why SEG$ table has 0 ini_trans

  • From: "Bajwa, Sandeep" <ssb14@xxxxxxxx>
  • To: "niall.litchfield@xxxxxxxxx" <niall.litchfield@xxxxxxxxx>, "howard.latham@xxxxxxxxx" <howard.latham@xxxxxxxxx>
  • Date: Tue, 10 Nov 2015 16:20:45 +0000

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2015