Re: Why SEG$ table has 0 ini_trans

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 10 Nov 2015 19:30:36 +0300
Message-ID: <CAOVevU7uXpdUrNUzX-BFVdgwH6rHUtnBwBR9ixLK9g_26_KBZw_at_mail.gmail.com>



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> 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
Received on Tue Nov 10 2015 - 17:30:36 CET

Original text of this message