Script chunksml.tcl does not handle AUTO ALLOCATION tablespaces

From: Luis Santos <lsantos_at_pobox.com>
Date: 7 Apr 2003 11:51:41 -0700
Message-ID: <c0ef83a3.0304071051.208892c0@posting.google.com>

Hi,

I have found that the version of the script chunksml.tcl (used by OEM to find out segments that will fail to allocate a NEXT extent) bundled with RDBMS 8.1.7 (Date 20-apr-00.08:39:50 jmansur) does not check if the version of the database is 8.1+. These version have the AUTO ALLOCATION tablespace feature, where you specify that a tablespace is EXTENT MANAGEMENT LOCAL with AUTO ALLOCATION. In this case Oracle determines (by a smart algorithm) the NEXT value of the segment.

The problem is that the value of NEXT in the DBA_SEGMENTS is set to NULL to segments that are created on such tablespaces.

The version above does not handle this. The version bundled with Oracle 9.0.1 checks is the version is 8.1+, but only ignores such tablespaces (allocation_type=SYSTEM in DBA_TABLESPACES). See:

(...)

append sql " from sys.dba_segments s

where s.segment_type not in ('CACHE', 'DEFERRED ROLLBACK')

             and s.tablespace_name in
                ( select tablespace_name from sys.dba_tablespaces
                  where status = 'ONLINE' "
    if {[string compare $db_version "81"] >= 0} {
        append sql " and allocation_type != 'SYSTEM'"

}
(...)

I don´t have the version 9.2 to check.

Does anoone has a version that handles the segments created on AUTO ALLOCATION LOCALLY MANAGED tablespaces?

Best regards,
Luis Santos Received on Mon Apr 07 2003 - 13:51:41 CDT