Re: Why SEG$ table has 0 ini_trans

concerning the bootstrap role of SEG$ would could take a look at Tanel Poder's video
http://blog.tanelpoder.com/2011/08/11/full-scans-direct-path-reads-and-ora-8103-error-hacking-session-video-here-plus-itunes-podcast-address-2/ - the explanation of seg$ comes around min 50 - but it is certainly worth viewing completely.

Regards

Martin Preiss

Am 10.11.2015 um 17:20 schrieb Bajwa, Sandeep:
>
> 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
>

--
http://www.freelists.org/webpage/oracle-l