Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!m73g2000cwd.googlegroups.com!not-for-mail From: "sybrandb" Newsgroups: comp.databases.oracle.server Subject: Re: Extent inffo does not match table size ? Date: 10 Oct 2006 01:32:06 -0700 Organization: http://groups.google.com Lines: 52 Message-ID: <1160469126.328534.42740@m73g2000cwd.googlegroups.com> References: <1160468080.022026.197530@c28g2000cwb.googlegroups.com> NNTP-Posting-Host: 192.33.238.6 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1160469132 25244 127.0.0.1 (10 Oct 2006 08:32:12 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 10 Oct 2006 08:32:12 +0000 (UTC) In-Reply-To: <1160468080.022026.197530@c28g2000cwb.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 PXYBEBR003 Complaints-To: groups-abuse@google.com Injection-Info: m73g2000cwd.googlegroups.com; posting-host=192.33.238.6; posting-account=d8kqXg0AAADvDUR8IdYEU7pAZnZ1O2PC Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276899 On Oct 10, 10:14 am, "Martin T." 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. -- Sybrand Bakker Senior Oracle DBA