Re: Locally Managed Tablespaces

We are using LMTs with several of our databases. No problems. With these databases we are also running large file systems. Although our OS imposes a theoretical limit of 31.9999G, we have kept our datafiles to 20G or less. Again, no problems.

Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
pnbarne_at_regence.com

On Tue, 17 Apr 2001, Patricia Ashe wrote:

>
> I am interested in some statistics on Oracle locally managed tablespaces. I
> have been looking for any bugs or negative info about them. Are they in use
> at alot of sites? Seems like all the information I have come across is
> positive. Which is great! But maybe they aren't being used at alot of
> sites. Can I hear about experiences from others on this list? how many
> sites are actually using them?
> I have several databases that I am getting ready to go production soon and
> would like to create the tablespaces as locally managed, but need more
> statistics.
>
> PA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Patricia Ashe
> INET: pashe_at_TRUELINK.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett 
  INET: pnbarne_at_bcbso.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).