From oracle-l-bounce@freelists.org Fri Feb 27 10:36:30 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1RGaUd09685 for ; Fri, 27 Feb 2004 10:36:30 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1RGaSo09679 for ; Fri, 27 Feb 2004 10:36:29 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BC3A139533E; Fri, 27 Feb 2004 11:35:45 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 27 Feb 2004 11:34:24 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ext-nj2gw-3.online-age.net (ext-nj2gw-3.online-age.net [216.35.73.165]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4848D39506D for ; Fri, 27 Feb 2004 11:33:48 -0500 (EST) Received: from int-nj2gw-5.online-age.net (int-nj2gw-5 [3.159.236.69]) by ext-nj2gw-3.online-age.net (8.12.9/8.12.9/990426-RLH) with ESMTP id i1RGaoH5014512 for ; Fri, 27 Feb 2004 11:36:51 -0500 (EST) Received: from AP3EXVW01APPLGE.appl.ge.com (localhost [127.0.0.1]) by int-nj2gw-5.online-age.net (8.12.9/8.12.8/990426-RLH) with SMTP id i1RGanJA002438 for ; Fri, 27 Feb 2004 11:36:50 -0500 (EST) Received: from 3.130.163.181 by AP3EXVW01APPLGE.appl.ge.com (InterScan E-Mail VirusWall NT); Fri, 27 Feb 2004 11:36:50 -0500 Received: by ap3exbh01applge.appl.ge.com with Internet Mail Service (5.5.2657.72) id ; Fri, 27 Feb 2004 11:36:49 -0500 Message-ID: From: "Adams, Matthew (GE Consumer & Industrial)" To: "'oracle-l@freelists.org'" Subject: locally managed with autoallocation Date: Fri, 27 Feb 2004 11:36:47 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-294a89b5-792b-47c5-aded-06a13d4de7fa" X-archive-position: 2245 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: MATT.ADAMS@APPL.GE.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPartTM-000-294a89b5-792b-47c5-aded-06a13d4de7fa Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FD4F.B432A9EE" ------_=_NextPart_001_01C3FD4F.B432A9EE Content-Type: text/plain; charset="iso-8859-1" I know we are WAY behind the times here, still using dictionary managed tablespaces for everything. I'm starting to evaluate methods for setting up tablespaces and have to ask this: Why would anyone use autoallocation with locally managed tablespaces when it appears to be open to the same kind of honeycombing fragmentation problems that exist with dictionary tablespaces that don't use uniform extent sizes? Natt ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com When I'm around hard-core computer geeks, I want to say, 'Come outside -- the graphics are great!' - Matt Weinhold ------_=_NextPart_001_01C3FD4F.B432A9EE Content-Type: text/html; charset="iso-8859-1" locally managed with autoallocation

I know we are WAY behind the times here, still using
dictionary managed tablespaces for everything.  I'm starting to
evaluate methods for setting up tablespaces and have to
ask this:

Why would anyone use autoallocation with locally managed
tablespaces when it appears to be open to the same kind
of honeycombing fragmentation problems that exist with
dictionary tablespaces that don't use uniform extent sizes?

Natt

----
Matt Adams - GE Appliances - matt.adams@appl.ge.com
When I'm around hard-core computer geeks, I want
to say, 'Come outside -- the graphics are great!'
    - Matt Weinhold

------_=_NextPart_001_01C3FD4F.B432A9EE-- ------=_NextPartTM-000-294a89b5-792b-47c5-aded-06a13d4de7fa-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------