Re: MAX_EXTENTS

Hello,

MAX_EXTENTS of TS are used as default for the objects like table created in that tablespace without specifying MAX_EXTENTS as storage parameter...

When you sum.. it is gives the sum for all the objects that are there in a particular tablespace....

This that help you in analyzing and answering your querry ??

Any suggestions / corrections ?

Nikunj

• Original Message ----- From: "TheOracle DBA" <theoracledba_at_lycos.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 09, 2000 10:43 AM Subject: Re: MAX_EXTENTS

> In the DBA_TABLESPACE view, the column "max_extents" refers to the default
storage paramters for any segment created in that specific TS without explicit storage settings,
>
> so you can set the DEF to be max=400, but create a table TESTMAXEXT and
give it storage ( maxextents 1012)
>
>
>
> On Thu, 09 Nov 2000 10:05:47
> Terry Ball wrote:
> >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
> >> Til.: 01-46-39-14-49
> >> Fax : 01-46-39-59-88
> >
>
>
> Get FREE Email/Voicemail with 15MB at Lycos Communications at
http://comm.lycos.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: TheOracle DBA
> INET: theoracledba_at_lycos.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Nov 10 2000 - 00:30:42 CST