RE: MAX_EXTENTS

From: Shawn Ferris <Shawn.Ferris_at_twtelecom.com>
Date: Thu, 9 Nov 2000 12:15:35 -0700
Message-Id: <10675.121621@fatcity.com>

MAX_EXTENTS at the tablespace level is a default for objects created = within
the tbsp that weren't given a storage clause to modify it explicitly.
=20

count(*) from dba_extents gives you the total extents allocated for the entire tablespace. Every object within. Each of which could have a = maximum
of 1017 extents per. (Given that they defaulted to the tbsp default.)
=20

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom=20
=20

 -----Original Message-----
From: DEMANCHE Luc (Cetelem) [mailto:luc.demanche_at_cetelem.fr] Sent: Thursday, November 09, 2000 9:31 AM To: Multiple recipients of list ORACLE-L 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 Received on Thu Nov 09 2000 - 13:15:35 CST