Oracle-L: LMT- Migrated tablespaces

From: Browett, Darren <dbrowett_at_coquitlam.ca>
Date: Fri, 27 Dec 2002 10:13:42 -0800
Message-ID: <F001.00523476.20021227101342@fatcity.com>

I have crossposted this question on the Oracle-Apps list, I would like to
get the opinion of this list as it is more of database issue as opposed to apps.

The question is about LMT and extent management with regards to Oracle 11i.

When upgrading to 11i, it creates "migrated" LMTS as opposed to "uniform/system" ones, and therefore do not conform to the rules of "correct" LMTS.

My understanding is, even though my tablespaces are LMT, the tables still act like they are dictionary managed with regards to extent growth.

According to "How to stop defrag, and start living ....." for tables under 160M I should have an extent size of 160k.

With that in mind, should I

Create LMT Tablespaces with an extent size of 160k ? ( This is ignored by the import, tables will be one extent big)
Reset the "next_extent" on my apps tables to 160k ?
Set pctincrease to 0 ? ( I think this is a given )

Thanks

Darren

Darren Browett P.Eng This
message was transmitted
Data Administrator using
100% recycled electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Browett, Darren
INET: dbrowett_at_coquitlam.ca

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). Received on Fri Dec 27 2002 - 12:13:42 CST