Hi Christy,
What tool were you using to check the extents?
- "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
> --
> 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).
>
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Wed May 03 2000 - 08:55:56 CDT