| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Newbie Question - weird extents
Thanks for the ideas, Rachel & Chuck -
I don't *think* the tables had more records at any time, but I can't be positive about that. There are some application consultants here doing some data loads, and I suppose it is conceivable that they somehow loaded a boatload of records into those two (incorrect) tables, realized their mistake, and deleted the loaded lines... since I last reorg'd the records 4 working days ago... There's no way to tell, is there?
I don't remember hearing that extents aren't deallocated when data is deleted (in class) - good to know, thanks.
-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Wednesday, May 03, 2000 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Newbie Question - weird extents
Christy,
did those tables hold more records at one point or another? If you have deleted records, Oracle does NOT deallocate the extents. That is one possible explanation.
Rachel
>From: "Warthling, Christy" <cwarthling_at_CharterOneBank.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Newbie Question - weird extents
>Date: Wed, 03 May 2000 06:14:08 -0800
>
>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).
-- Author: Rachel Carmichael INET: carmichr_at_hotmail.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 mayReceived on Wed May 03 2000 - 13:14:10 CDT
 |
 |