RE: Newbie Question - weird extents

2 reasons I can think of
1) the minextents parameter was used creating the table (less likely). 2) There were more than 14 rows in there at 1 time. Maybe there was 1000
(Oracle took the space it needed at the time), then many of the rows were
deleted (Oracle won't give back that space, you can coalesce though). What you did was normal, most DBA's defragment their tables.

        To minimize this you could create one bigger extent (Oracle will reuse space within an extent), and you would not have this problem.

-----Original Message-----
From: Warthling, Christy [mailto:cwarthling_at_CharterOneBank.com] Sent: Wednesday, May 03, 2000 10:14 AM
To: Multiple recipients of list ORACLE-L Subject: Newbie Question - weird extents

Hi all -

Being new to Oracle, I'm not sure if this is a common occurrence or if it indicates anything in particular.

We have an application (Lawson) using Oracle 8.1.5 (on NT, more's the pity). I have been checking file sizes pretty religiously since I'm new, the system is new, and we just went into production.

Yesterday a consultant (very helpful one, btw) was here helping me with some other issues, and we noticed that two of the tables seemed to have an oddly large number of extents (one had 49, one had 36 or so). Strange, considering that each table had only 14 records and the initial extent should have been plenty large enough to hold way more than that. We ended up exporting/truncating tables/recreating/importing the data, which worked fine.

But I'm curious to know if there's any way I can figure out why they seemed to break up like that - what do you all think?

TIA for any ideas -

Christy
cwarthling_at_charteronebank.com

-- 
Author: Warthling, Christy
  INET: cwarthling_at_CharterOneBank.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

also send the HELP command for other information (like subscribing).