Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id g9T9U2p14490 for ; Tue, 29 Oct 2002 03:30:02 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id g9T9U2R14484 for ; Tue, 29 Oct 2002 03:30:02 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id XAA35309; Mon, 28 Oct 2002 23:11:17 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004F5D22; Mon, 28 Oct 2002 22:33:35 -0800 Message-ID: Date: Mon, 28 Oct 2002 22:33:35 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Tom Pall" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Tom Pall" Subject: Re: Convert DM TSP to LM TSP w/ lots of data Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_029C_01C27EE2.6C98D820" ------=_NextPart_000_029C_01C27EE2.6C98D820 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I tried having Oracle convert DMT to LMT out a few times on 10 GB = tablespaces. Whether or not that's a lot of data depends on you. = Worked like a champ. And this was in the early days of LMT. People who = pay a lot of attention to the internals will warn you that converting a = DMT to LMT is not optimal. Your bitmaps wind up at the end of the files = instead of the headers. I've read posts here and elsewhere where people worried about the same = issues as they did with DMT. They wanted to limit the number of extents = segments grew to by creating tablespaces with different sized fixed = extents. A DBA I worked with pointed out how very easy and quickly = things worked with letting Oracle automatically size the next extent. = I've gone that way whenever possible and have never regretted it. I've = not done a rigorous benchmark but can tell you from casual observation = dropping an object with lots of extents doesn't happen in the blink of = an eye but doesn't lock out all other space allocation as UET/FET = weren't constantly in use and the ST enque wasn't locked for exclusive = use. It's prudent to follow Oracle's recommendations if conditions permit. = Create a new LMT and move your data to it. ----- Original Message -----=20 From: Govind.Arumugam@alltel.com=20 To: Multiple recipients of list ORACLE-L=20 Sent: Monday, October 28, 2002 8:43 PM Subject: Convert DM TSP to LM TSP w/ lots of data I am reposting this. Has anyone tried to convert a dictionary managed = table space containing lots of data to locally managed? We have tried = this out successfully on empty table spaces or created a new LMT = tablespace and moved the existing objects to it.=20 Thanks,=20 Govind ------=_NextPart_000_029C_01C27EE2.6C98D820 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I tried having Oracle convert DMT = to=20 LMT out a few times on 10 GB tablespaces. Whether or not = that's a lot=20 of data depends on you. Worked like a champ. And this was in = the=20 early days of LMT. People who pay a lot of attention to the = internals will=20 warn you that converting a DMT to LMT is not optimal. Your bitmaps = wind up=20 at the end of the files instead of the headers.

I've read posts here and = elsewhere where=20 people worried about the same issues as they did with DMT. They = wanted to=20 limit the number of extents segments grew to by creating tablespaces = with=20 different sized fixed extents. A DBA I worked with pointed out how = very=20 easy and quickly things worked with letting Oracle automatically size = the next=20 extent. I've gone that way whenever possible and have never = regretted=20 it. I've not done a rigorous benchmark but can tell you from = casual=20 observation dropping an object with lots of extents doesn't happen = in the=20 blink of an eye but doesn't lock out all other space allocation as=20 UET/FET weren't constantly in use and the ST enque wasn't = locked for=20 exclusive use.

It's prudent to follow Oracle's = recommendations if=20 conditions permit. Create a new LMT and move your data to = it.

----- Original Message -----
From:=20 Govind.Arumugam@alltel.com=
To: Multiple recipients of list = ORACLE-L=20

Sent: Monday, October 28, 2002 = 8:43=20 PM

Subject: Convert DM TSP to LM = TSP w/ lots=20 of data

I am = reposting this.=20 Has anyone tried to convert a dictionary managed=20 table space containing lots of data to locally managed? We = have tried=20 this out successfully on empty table spaces or created a new LMT tablespace and moved the existing = objects=20 to it.

Thanks,

Govind

------=_NextPart_000_029C_01C27EE2.6C98D820-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: tpall@realtime.net 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@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).