Re: Why SEG$ table has 0 ini_trans

Yep. SeG$ is a bootstrap table and must not be changed (unless....there is an option, but you should not play with it. ;-) ). Therefore makes not much sense to comment on it's properties. There are some issues with waits it when you do a high parallel inserts using temp segment merge which is not because of the ini_trans but because of the table definition (index cluster).

regards

Lothar

On 10.11.2015 17:30, Sayan Malakshinov wrote:
> SYS.SEG$ is a special table:
> select * from sys.bootstrap$ where sql_text like '% SEG$%';
>
> that is created at startup
>
> On Tue, Nov 10, 2015 at 7:20 PM, Bajwa, Sandeep <ssb14_at_pitt.edu
> <mailto:ssb14_at_pitt.edu>> wrote:
>
> 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
>
>
>
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle ACE Associate
> Lead performance tuning engineer
> PSBank
> http://orasql.org

-- 





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