Locally Managed Tablespaces - Questions.

From: Ceri Townsend <dba_at_persistent-worlds.net>
Date: Fri, 11 Apr 2003 06:37:20 -0800
Message-ID: <F001.0057F7D4.20030411063720@fatcity.com>

Hi Listers,

I am in the process of setting up a new Oracle database on 9.2.0.3.0. I want to use locally managed tablespaces, but im not sure about the extent and segment management options. Should I use uniform extents? If so how do i determine a good size for these, or is the Oracle Default good enough. Also what about sement space management, what benefits can this provide me, any potential pitfalls i should watch out for? Also should i make my system tablespace locally managed also? Does this mean i then cant create dictionary managed tablespaces?

All help appreciated, or point me to a good artical.

Thanks

Ceri
--

Ceri Database Admin mailto:dba_at_persistent-worlds.net ICQ:153010767

"I love deadlines. I like the whooshing sound they make as they fly by." Douglas Adams

--

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

Author: Ceri Townsend
  INET: dba_at_persistent-worlds.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_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 Apr 11 2003 - 09:37:20 CDT