Message-Id: <10675.121597@fatcity.com> From: "DEMANCHE Luc (Cetelem)" Date: Thu, 9 Nov 2000 16:05:16 +0100 Subject: MAX_EXTENTS This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04A5E.7842B8D6 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 = ? TIA=20 -----------------=20 Luc Demanche=20 CETELEM=20 T=E9l.: 01-46-39-14-49=20 Fax : 01-46-39-59-88=20 ------_=_NextPart_001_01C04A5E.7842B8D6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MAX_EXTENTS

Hi gurus,

I noticed a little weird thing : =

FICOMOP> select max_extents from = dba_tablespaces where tablespace_name =3D 'TBS_TRAVAIL';

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

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

  COUNT(*)
----------
     19402

Why the maximum number of extents = defined in dba_tablespaces is 1017 and I have 19402 extents created in = my tablespace.

Is it the maximum number of extents = per datafile or for the tablespace ?

TIA


-----------------
Luc Demanche
CETELEM
T=E9l.: 01-46-39-14-49
Fax : 01-46-39-59-88