Re: questions regarding extents' total

From: Saar <sxmaxoz_at_us.oracle.com>
Date: Wed, 01 Jul 1998 11:39:43 -0700
Message-ID: <359A826E.E695D028@us.oracle.com>

Shuang Li wrote:

> Hi everybody,
>
> Could anyone out there tell me how I can find out the total number of
> extents for a specific table?

SVRMGR> desc user_extentsColumn Name                    Null?    Type
------------------------------ -------- ----
SEGMENT_NAME                            VARCHAR2(81)
PARTITION_NAME                          VARCHAR2(30)
SEGMENT_TYPE                            VARCHAR2(17)
TABLESPACE_NAME                         VARCHAR2(30)
EXTENT_ID                      NOT NULL NUMBER
BYTES                                   NUMBER
BLOCKS                         NOT NULL NUMBER

look at dba_extents as well.

> I know how for a specifc tablespace. But
> can't find a dba table containing the total number of extents and a table
> name. Basically what I want to do is to locate those tables who have too
> many extents and rebuild their indexes.
>

why would you want to rebuild the INDEXES? maybe the indexes have OK number ofextents. I would expect you'd want to rebuild these TABLES that have too many
extents.

> Thanks a lot!
>
> Shuang
>
> ******************************************************
> * *
> * NOTHING AGES AS FAST AS HAPPINESS *
> * --- Les Miserables *
> * *
> ******************************************************
> http://www.cs.umbc.edu/~sli1 410-455-3082(O)

 __  _    _  __    _ _   _   _ ___  ______________________________
((  /\\  /\\ ||)  |\V/| /\\ /\\ >/  Principal Performance Engineer

_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Digital SBU

////////////////// Drop x's in email (spam) //////////////////////

Received on Wed Jul 01 1998 - 13:39:43 CDT