Sandeep,
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@xxxxxxxx <mailto:ssb14@xxxxxxxx>> 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