Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!i3g2000cwc.googlegroups.com!not-for-mail
From: "Martin T." <bilbothebagginsbab5@freenet.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Extent inffo does not match table size ?
Date: 10 Oct 2006 03:33:23 -0700
Organization: http://groups.google.com
Lines: 70
Message-ID: <1160476403.050045.140140@i3g2000cwc.googlegroups.com>
References: <1160468080.022026.197530@c28g2000cwb.googlegroups.com>
   <1160469126.328534.42740@m73g2000cwd.googlegroups.com>
NNTP-Posting-Host: 80.120.195.26
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160476407 5671 127.0.0.1 (10 Oct 2006 10:33:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 10:33:27 +0000 (UTC)
In-Reply-To: <1160469126.328534.42740@m73g2000cwd.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 GRZ-ISA-KS
Complaints-To: groups-abuse@google.com
Injection-Info: i3g2000cwc.googlegroups.com; posting-host=80.120.195.26;
   posting-account=Doh9dQ0AAAAZpkwYjZionMedl4o1AVmV
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276902

sybrandb wrote:
> On Oct 10, 10:14 am, "Martin T." <bilbothebagginsb...@freenet.de>
> wrote:
> > (O 9.2.0.1.0)
> >
> > Ok, so obviously I haven't quite understood something here, hope s/o
> > can help.
> >
> > When I look at the Information on my table (using Toad), it reports:
> > STORAGE    (
> >             INITIAL          64K
> >             MINEXTENTS       1
> >             MAXEXTENTS       2147483645
> >             PCTINCREASE      0
> >             BUFFER_POOL      DEFAULT
> >            )
> >
> > However, it also reports:
> > Table Size = 128 MB
> > Number of Extents = 87
> >
> > So how can a table of 128MB be made up of 87 x 64KB?
> >
> > As I said, obviously I've either misunderstood something or look at the
> > wrong information :-)
> >
> > thanks,
> > Martin
> >
> > p.s.:
> > Tablespace:
> >
> > CREATE TABLESPACE "USERS"
> >     LOGGING
> >     DATAFILE '&2\ORADATA\&1\USERS01.DBF' SIZE 2048M
> >     AUTOEXTEND
> >     ON NEXT  10240K MAXSIZE  32767M EXTENT MANAGEMENT LOCAL
> >     SEGMENT SPACE MANAGEMENT  AUTO
> > /
>
>
>
> tablespace ... AUTOALLOCATE (default) (no uniform extent sizes)
> Please look in DBA or USER_EXTENTS for this table and notice Oracle
> automagically increases every new extent.
> And yes, obviously this has been discussed before here.
>
Thank you!

cheers,
Martin

p.s.: I should have looked up the Create Tablespace stmt, not the
Create Table stmt:

*extent_management_clause*

The extent_management_clause lets you specify how the extents of the
tablespace will be managed.

o Specify LOCAL if you want the tablespace to be locally managed.
Locally
managed tablespaces have some part of the tablespace set aside for a
bitmap.
/This is the default./

o AUTOALLOCATE specifies that the tablespace is system managed. Users
cannot specify an extent size. /This is the default/ if the COMPATIBLE
initialization parameter is set to 9.0.0 or higher.