MAX_EXTENTS

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Thu, 9 Nov 2000 16:05:16 +0100
Message-Id: <10675.121597@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<TITLE>MAX_EXTENTS</TITLE>
</HEAD>
<BODY>

Hi gurus,

<P><FONT SIZE=3D2 FACE=3D"Arial">I noticed a little weird thing : =
</FONT>
</P>

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

<P><FONT SIZE=3D2 FACE=3D"Arial">MAX_EXTENTS</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

1017

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

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; COUNT(*)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp; 19402</FONT>
</P>

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 ?

<P><FONT SIZE=3D2 FACE=3D"Arial">TIA</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">-----------------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Luc Demanche</FONT>
<BR><B><I><FONT FACE=3D"Arial">CETELEM</FONT></I></B>

T=E9l.: 01-46-39-14-49 Fax : 01-46-39-59-88 Received on Thu Nov 09 2000 - 09:05:16 CST