Message-Id: <10675.121622@fatcity.com> From: "Natasha Batson" Date: Thu, 9 Nov 2000 15:25:12 -0400 Subject: Re: MAX_EXTENTS This is a multi-part message in MIME format. ------=_NextPart_000_0322_01C04A61.40DECBC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MAX_EXTENTSLuc Read what "TheOracleDBA" has responded with regarding your question. ----- Original Message -----=20 From: DEMANCHE Luc (Cetelem)=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, November 09, 2000 12:31 PM 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 T=E9l.: 01-46-39-14-49=20 Fax : 01-46-39-59-88=20 ------=_NextPart_000_0322_01C04A61.40DECBC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MAX_EXTENTS
Luc
 
Read what "TheOracleDBA" has responded = with=20 regarding your question.
 
 
 
----- Original Message -----
From:=20 DEMANCHE Luc (Cetelem) =
To: Multiple recipients of list = ORACLE-L=20
Sent: Thursday, November 09, = 2000 12:31=20 PM
Subject: MAX_EXTENTS

Hi gurus,

I noticed a little weird thing : =

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

MAX_EXTENTS
-----------
       1017

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

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

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

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

TIA


-----------------
Luc Demanche
CETELEM=20
T=E9l.: 01-46-39-14-49 =