Re: Newbie Question - weird extents

Inserts/deletes is a good point. The application could have created the table with a lot of extents. MINEXTENTS could have been high.

HTH
Lyall Barbour

------Original Message------
From: bill thater <thaterw_at_telergy.net>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 3, 2000 3:47:09 PM GMT
Subject: 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





--
Author: bill thater
INET: thaterw_at_telergy.net

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).

______________________________________________