extent blowout

From: jabs <no_at_email.com>
Date: Sun, 11 May 2003 03:40:36 GMT
Message-ID: <UCjva.66701$4P1.6014532@newsread2.prod.itd.earthlink.net>

I'm loading data into a 9i database (9.2) using PL/SQL for a data warehouse. We are using local tablespaces (128mb in this case). When I load particular tables, they use many more extents than they should be. I can move the tablespace to somewhere else, move it back, and it's less than half the size.

The PL/SQL map is very simple logic. I've rebuilt the table without specifying initial/next parameters, - since it's a truncate/insert, I specified pctfree 2 <I've also tried 10>. There are no indexes on the table. The dbas I'm working with haven't come up with anything yet.

TIA, and let me know if you need more info. Thanks again!

jabs. Received on Sat May 10 2003 - 22:40:36 CDT