RE: Locally Managed Tablespaces

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:pashe_at_TRUELINK.com]
> 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.
Received on Wed Apr 18 2001 - 13:32:47 CDT