Re: LMT monitoring

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" <ORACLE-L_at_fatcity.com> 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" <ORACLE-L_at_fatcity.com>
> 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: jonathan_at_jlcomp.demon.co.uk

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