Re: Newbie Question - weird extents

On May 3, Rocky Welch scribbled on the wall in glitter crayon:

->Hi Christy,
->What tool were you using to check the extents?

could it also have been that a lot of insert/delete pairs were run on those tables leaving only a few records in place?

->
->--- "Warthling, Christy" <cwarthling_at_CharterOneBank.com> wrote:
->> 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

--
Bill Thater             Certified ORACLE DBA
Telergy, Inc.            thaterw_at_telergy.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Do or not do.  There is no try.  -- Yoda	
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Study = NoFail NoStudy = Fail .............. Study + NoStudy = Fail + No Fail Study(1 + No) = Fail(1 + No) ergo, Study = Fail