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 Received on Wed May 03 2000 - 08:03:09 CDT