Based on these two points: > The version is 8.1.7.1.0 > The table is populated by sqlldr direct path.
I have a bit of gossip (i.e. someone I know told me that someone he knows told him that he'd heard that ...) there have been cases where parallel execution slaves have applied extent trimming in locally managed tablespaces in operations like CTAS and create index - even though they clearly should not. I haven't tried to test this myself. Perhaps, given you have a low release of 8.1.7, and given that there is probably some code overlap between PX create and SQL direct load perhaps you are coming across the same issue. One detail worth checking is that every extent in an Autoallocate tablespace should probably be on the 'correct' boundary - i.e. an 8M extent should start a multiple of 8M from the bitmap, a 1M extent should start a multiple of 1M from the bitmap and so on. (This is something that I have observed, but not yet proved in 9.2). Are your odd-sized extents packed in next to each other, or do they start at 8M boundaries, leaving gaps of 2 to 6 MB ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Now available One-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) ____UK_______March 19th ____UK_______April 8th ____UK_______April 22nd ____USA_(FL)_May 2nd Next dates for the 3-day seminar: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____UK_(Manchester)_May ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: 11 March 2003 12:23 > The version is 8.1.7.1.0 > > The report is via this query: > SELECT partition_name, extent_id, bytes/1024, bytes/1024/1024 > FROM dba_extents > WHERE segment_name = 'FORMATTER_DATA_HISTORY' > AND owner = 'KEVIN' > ORDER BY 1, 2 > > The file is not autoextent. > The table is populated by sqlldr direct path. > The tablespace is locally managed with system allocated extents > TABLESPACE_NAME EXTENT_MAN ALLOCATIO > ------------------------------ ---------- --------- > KEVIN_TS LOCAL SYSTEM > > Kevin > > > -----Original Message----- > Sent: Monday, March 10, 2003 5:21 PM > To: Multiple recipients of list ORACLE-L > > > > > Which version of Oracle ? > How are you getting the report ? > Is the file autoextent - if so at what unit ? > How are you filling the table ? > Is the tablespace ASS Managed ? > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Now available One-day tutorials: > Cost Based Optimisation > Trouble-shooting and Tuning > Indexing Strategies > > (see http://www.jlcomp.demon.co.uk/tutorial.html ) > > ____UK_______March 19th > ____UK_______April 8th > ____UK_______April 22nd > > ____USA_(FL)_May 2nd > > > Next dates for the 3-day seminar: > (see http://www.jlcomp.demon.co.uk/seminar.html ) > > ____UK_(Manchester)_May > ____USA_(CA, TX)_August > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: 10 March 2003 21:02 > > > > As mydata load continues, the saga continues. The simplistic > algorithm does > > not hold.... > > > > Can anyone explain these results? > > > > PARTITION_NAME EXTENT_ID BYTES/1024 BYTES/1024/1024 > > ------------------------------ ---------- ---------- --------------- > > FINS_FM_DATA_CLOSED_200207 84 6144 6 > > FINS_FM_DATA_CLOSED_200207 85 5120 5 > > FINS_FM_DATA_CLOSED_200207 86 6144 6 > > FINS_FM_DATA_CLOSED_200207 87 5120 5 > > FINS_FM_DATA_CLOSED_200207 88 5120 5 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
