Re: MAX_EXTENTS

From: Natasha Batson <nbatson_at_neal-and-massy.com>
Date: Thu, 9 Nov 2000 15:25:12 -0400
Message-Id: <10675.121622@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>MAX_EXTENTS</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Luc</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Read what "TheOracleDBA" has responded =

with=20
regarding your question.</DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A title=3Dluc.demanche_at_cetelem.fr=20
 href=3D"mailto:luc.demanche_at_cetelem.fr">DEMANCHE Luc (Cetelem)</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">To: <A = title=3DORACLE-L_at_fatcity.com=20
 href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
 </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Thursday, November 09, = 2000 12:31=20
 PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> MAX_EXTENTS</DIV>
  <DIV><BR></DIV>
  <P><FONT face=3DArial size=3D2>Hi gurus,</FONT> </P>
  <P><FONT face=3DArial size=3D2>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

  <P><FONT face=3DArial size=3D2>-----------------</FONT> <BR><FONT =

face=3DArial=20
size=3D2>Luc Demanche CETELEM=20
 T=E9l.: 01-46-39-14-49 = <FONT face=3DArial=20 Received on Thu Nov 09 2000 - 13:25:12 CST