Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
> 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
![]() |
![]() |