Re: Why SEG$ table has 0 ini_trans

From: Martin Preiss <mtnpreiss@xxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 10 Nov 2015 19:49:55 +0100

Sandeep,

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

Follow-Ups:
- Re: Why SEG$ table has 0 ini_trans
  - From: Tanel Poder

References:
- Why SEG$ table has 0 ini_trans
  - From: Bajwa, Sandeep

Other related posts:

» Why SEG$ table has 0 ini_trans- Bajwa, Sandeep
» Re: Why SEG$ table has 0 ini_trans- Sayan Malakshinov
» RE: Why SEG$ table has 0 ini_trans- Powell, Mark
» RE: Why SEG$ table has 0 ini_trans- Jonathan Lewis
» Re: Why SEG$ table has 0 ini_trans- Lothar Flatz
» Re: Why SEG$ table has 0 ini_trans - Martin Preiss
» Re: Why SEG$ table has 0 ini_trans- Tanel Poder