Re: Number of Extents in each table? and how to use Analyze?

From: Dan Jackson <danieljackson_at_att.com>
Date: Thu, 22 Oct 1998 13:58:35 -0400
Message-ID: <362F724B.C389033F@att.com>

A single segment can have one or more extents. The EXTENTS column that you
mentioned is in the USER_SEGMENTS, not in USER_EXTENTS, and yes, it has the correct number of extents for the table. I regularly run queries against
USER_SEGMENTS to see which tables are growing (i.e. which have >1 extents )

The output from ANALYZE is contained in USER_TABLES, USER_INDEXES, and USER_TAB_COLUMNS. It does NOT contain EXTENT information, but it does have number of blocks, row chaining, etc... You can use DBMS_UTILITY.ANALYZE_SCHEMA('schema_name','COMPUTE') to perform computational statistics on an entire schema. If it's not available, run dbmsutil.sql script.

Dan Received on Thu Oct 22 1998 - 12:58:35 CDT