Re: MAX_EXTENTS

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Thu, 09 Nov 2000 12:03:07 -0600
Message-Id: <10675.121611@fatcity.com>

--------------9B1277ED2A359CEA1F732A06
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Because you have multiple segments in the tablespace, each with one or more extents of there own, but you have one segment that has 1017 extents all by itself.

Terry

"DEMANCHE Luc (Cetelem)" wrote:

>
>
> Hi gurus,
>
> I noticed a little weird thing :
>
> FICOMOP> select max_extents from dba_tablespaces where tablespace_name
> = 'TBS_TRAVAIL';
>
> MAX_EXTENTS
> -----------
> 1017
>
> FICOMOP> select count(*) from dba_extents where tablespace_name =
> '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él.: 01-46-39-14-49
> Fax : 01-46-39-59-88

--------------9B1277ED2A359CEA1F732A06
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
Because you have multiple segments in the tablespace, each

<br>with one or more extents of there own, but you have one
<br>segment that has 1017 extents all by itself.
<p>Terry
<p>"DEMANCHE Luc (Cetelem)" wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font face="Arial"><font size=-1>Hi gurus,</font></font>
<p><font face="Arial"><font size=-1>I noticed a little weird thing :</font></font>
<p><font face="Arial"><font size=-1>FICOMOP> select max_extents from dba_tablespaces

where tablespace_name = 'TBS_TRAVAIL';

<p><font face="Arial"><font size=-1>MAX_EXTENTS</font></font>
<br><font face="Arial"><font size=-1>-----------</font></font>
<br><font face="Arial"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

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

<p><font face="Arial"><font size=-1>&nbsp; COUNT(*)</font></font>
<br><font face="Arial"><font size=-1>----------</font></font>
<br><font face="Arial"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp; 19402</font></font>
<p><font face="Arial"><font size=-1>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 face="Arial"><font size=-1>TIA</font></font>
<p><font face="Arial"><font size=-1>-----------------</font></font>
<br><font face="Arial"><font size=-1>Luc Demanche</font></font>
<br><b><i><font face="Arial">CETELEM</font></i></b>
<br><font face="Arial"><font size=-1>T&eacute;l.: 01-46-39-14-49</font></font>
<br><font face="Arial"><font size=-1>Fax : 01-46-39-59-88</font></font></blockquote>

Received on Thu Nov 09 2000 - 12:03:07 CST