I'm using LMTs with the UNIFORM EXTENT option on 8.1.6[.2], with great
results. Two caveats I've noticed:
1) If you want to use LMTs for rollback segments, you MUST create at
least one rollback segment in a dictionary managed tablespace first (in
addition to the ever-present "system" RBS). This is bug#1176609, which
you can lookup on Metalink... assuming that the palm pilot they're
using as a webserver is up, of course. (-:
2) If you want to make your TEMP tablespace locally managed (i.e.
created using TEMPFILE instead of DATAFILE), it will be created sparse
on Unix systems. This means that (for example) you *won't* get an
error if you inadvertently attempt to create a file larger than it's
host filesystem... not up front, anyway. If that non-existent tempfile
space is ever needed, you'll certainly get errors at that point
(especially nasty if one of your control files is in the same
filesystem). So make absolutely certain that the file size is entered
correctly.
According to Oracle Support, #2 is a documentation error which will be
corrected in 9i. I've been meaning to submit an enhancement request,
asking that file > filesystem be treated as an error, but haven't
actually done it yet.
Cheers!
> -----Original Message-----
> From: pashe [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 17, 2001 6:36 PM
> To: ORACLE-L
> Cc: pashe
> Subject: Locally Managed Tablespaces
>
>
>
> 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.
