Number of extents

From: Thanh-truc Nguyen <nguyen_at_laposte.net>
Date: Fri, 08 Nov 2002 07:24:11 -0800
Message-ID: <F001.004FEC86.20021108072411@fatcity.com>

Hello,

I was very surprise when I saw what is below in the note 100960.1 at Metalink about the number of extents. Could-you give me your opinion please ?

1.4 OBJECTS WHICH DECREASE PERFORMANCE      Any object that is 
returned from the following query will decrease     
performance.  While the performance hit on over extended 
objects is not      significant, the aggregate effect on many 
over extended objects does impact     performance.       
ttitle 'All segments with >20 extents belonging to SYS' 
skip        clear breaks       clear computes       clear 
columns        column tablespace_name  format a15       column 
segment_name     format a30       column segment_type     
format a8        select  substr(tablespace_name,1,15) 
Tname,               segment_name,               
segment_type,               substr


(owner,1,10) "OWNER",               count


(*) "Extents",               blocks       from    


sys.dba_extents       where   owner != 'SYS'       group by 
tablespace_name,               segment_name,               
segment_type,               owner,               blocks       

having count(*) >20;

Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 €/mn) ; tél : 08 92 68 13 50 (0,34€/mn)"

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author:   INET: nguyen_at_laposte.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Fri Nov 08 2002 - 09:24:11 CST