RE: automatic segment space management

Dennis, who creates tables in your DB? If devs do, don't you worry that one could accidentally create a 512MB table in your 128K TS, instead of a 512KB one?

I really would like to implement LMTs here, and am doing so in certain restricted instances where I'm the only one who creates the objects for that TS, but I'm a little leery of letting it go to the developers, even though I don't use AUTOEXTEND.

Thx!

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Tuesday, September 03, 2002 12:42 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: automatic segment space management
>
>
> Rachel - I have been using LMTs with uniform extents
> (Oracle-recommended
> variation) for a couple of years now with Oracle 8.1.6, and
> now 9.2. The
> Oracle-recommended extent sizes are 128k, 4m, and 128m. As
> far as PCTFREE,
> et. al., these are at the table level, so my opinion would be that the
> guidelines for these are unchanged from the pre-LMT days. The
> key issue with
> the highly updated customer table would be whether the size
> of the row is
> changing. If you can keep the row size constant, then you
> won't wind up with
> chained rows. The biggest issue facing you is whether you
> turn AUTOEXTEND
> on. I did that and have encountered relatively few problems. Well, one
> problem. I had tables set with large NEXT extents to minimize
> extents, and
> when one extended boy did my sys admin get excited. I changed that.
> A bigger issue in building your data warehouse is whether
> you can use the
> partitioning option. Most of our queries were taking more
> than 2 minutes and
> I was able to partition and bring that down below 10 seconds.
> The users were
> pretty excited.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).