RE: LMT monitoring

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Toepke, Kevin M
  INET: ktoepke_at_trilegiant.com

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