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: =?iso-8859-1?Q?Thanh-truc_Nguyen? INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
