Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.belwue.de!news.Uni-Mainz.DE!not-for-mail From: Moritz Klein Newsgroups: comp.databases.oracle.server Subject: Re: changing SYSTEM-tablespace to automatic segment-space management Date: Fri, 11 Nov 2005 17:29:36 +0100 Organization: Johannes Gutenberg-Universitaet Mainz, Germany Lines: 36 Message-ID: References: <4374c14b$0$11067$e4fe514c@news.xs4all.nl> NNTP-Posting-Host: niles.vwl.uni-mainz.de Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news1.zdv.uni-mainz.de 1131726564 23436 134.93.204.9 (11 Nov 2005 16:29:24 GMT) X-Complaints-To: news@uni-mainz.de NNTP-Posting-Date: Fri, 11 Nov 2005 16:29:24 +0000 (UTC) User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: de-DE, de, en-us, en In-Reply-To: <4374c14b$0$11067$e4fe514c@news.xs4all.nl> Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:255236 Eric de Redelijkheid schrieb: > Why should your system tablespace be set to automatic space management > if you don't know the difference with manual space management? That said I do know the difference between automatic and manual space management. I did ask out of wondering why i got this advice. > With manual space management, the tables have all the old storage > proparties such as pctused, initial extent, next extent, etc. With > automatic segment space management, oracle takes care of most of this > automaticly, except pctfree. > Since in the system tablespace only tables and indexes from sys and > system should be there, I wonder why bother? I bother because OEM is telling me I should bother, but I was wondering about why SYSTEM would benefit from automatic space management, maybe it's just a general advice that's not tuned to exclude SYSTEM from the advise. What I am curious about is, that I did not decide at initial install (10.1.0.2) that SYSTEM should manual space management. I took the standard setting as proposed by Oracle and one release later it's telling me that I should change it??? Strange situation, but what the heck, easy to ignore this advice. > And I don't think it's possible to alter the storage parameters of a > locally managed tablespace, let alone system, without doing a full > export, drop the tablespace (in your case the entire database) and doing > a full import. If that's what I'm looking at I certainly won't change to automatic space management. In OEM it states the tablespace has to be reorganized, so if I want the tablespace to be operational I have to do a online reorganization. Anyway this seems to much uncertainty to deal with for now. Thanks for your answer, Moritz