Re: Newbie Question - weird extents

Christy,

Sound like your tables had been expanded before and now the number of extents (49/36) are like the high water mark of the tables.

IF you only have 14 records in those 49/36 extents table, there should be tons of free space inside those extents. Identified the file_id and the block_id from dba_extents which correspond to your tables. Then do a query on DBA_FREE_SPACE with the file_id and block_id. You should see plenty of rooms there.

But once your export/import the table, all those free space will be gone from the new tables.

If that happened again, tell your consultant to try that method and see.

Winnie

"Warthling, Christy" <cwarthling_at_CharterOneBank.com> on 05/03/2000 07:14:08 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Newbie Question - weird extents

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