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 1) Create LMT Tablespaces with an extent size of 160k ? ( This is ignored by the import, tables will be one extent big) 2) Reset the "next_extent" on my apps tables to 160k ? 3) 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:[EMAIL PROTECTED] ------------------------------------------------------------------------ --------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
