RE: Why SEG$ table has 0 ini_trans

From: Powell, Mark <mark.powell2_at_hpe.com>
Date: Tue, 10 Nov 2015 16:52:37 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD13067666F_at_G4W3290.americas.hpqcorp.net>

Why not just query directly from DBA_TABLES for the ini_trans value?

   select table_name, ini_trans
   from dba_tables
   where ini_trans = 0
   and owner = ‘SYS’
   order by 1

On a 10.2.0.5 EE system this returned 65 tables and 82 on an 11.2.0.3 Standard Ed system. You would need to dump the header block to see if Oracle allocated a default number of ITL’s in the block.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bajwa, Sandeep Sent: Tuesday, November 10, 2015 11:21 AM To: niall.litchfield_at_gmail.com; howard.latham_at_gmail.com Cc: ORACLE-L
Subject: Why SEG$ table has 0 ini_trans

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