RE: MAX_EXTENTS

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Thu, 9 Nov 2000 13:47:13 -0500
Message-Id: <10675.121618@fatcity.com>

Luc,

MAX_EXTENTS for the tablespace is just a default applied to any objects = you
create in the tablespace for which you don't specify a MAX_EXTENTS parameter.

Additionally, selecting count(*) from dba_extents gives you all of the extents for all of the segments in the tablespace. If you want to see = if
any particular objects have more than 1017 extents, run a query like = the
following:

select segment_name, segment_type, count(*) from dba_extents
group by segment_name, segment_type
having count(*) > 1017
/

Or, you can query dba_segments directly to see the number of extents = per
segment.

Regards,
Diana

-----Original Message-----
From: DEMANCHE Luc (Cetelem) [mailto:luc.demanche_at_cetelem.fr] Sent: Thursday, November 09, 2000 11:31 AM To: Multiple recipients of list ORACLE-L Subject: MAX_EXTENTS

Hi gurus,=20
I noticed a little weird thing :=20
FICOMOP> select max_extents from dba_tablespaces where tablespace_name = =3D
'TBS_TRAVAIL';=20

MAX_EXTENTS=20
-----------=20
       1017=20

FICOMOP> select count(*) from dba_extents where tablespace_name =3D
'TBS_TRAVAIL';=20

  COUNT(*)=20
----------=20
     19402=20

Why the maximum number of extents defined in dba_tablespaces is 1017 = and I
have 19402 extents created in my tablespace.=20 Is it the maximum number of extents per datafile or for the tablespace = ?=20
TIA=20

-----------------=20

Luc Demanche=20
CETELEM=20 Received on Thu Nov 09 2000 - 12:47:13 CST