| 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
Did the table previously have more rows that got deleted? Was there a
minextents value specified when the table was originally created?
--
Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA
"Warthling, Christy"
<cwarthling_at_CharterOn To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
eBank.com> cc: (bcc: CHUCK HAMILTON/QVC)
Ext: NA Subject: Newbie Question - weird extents
Sent by:
root_at_fatcity.com
05/03/00 10:14 AM
Please respond to
ORACLE-L
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 Liststo: 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). Received on Wed May 03 2000 - 10:06:08 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |