| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Locally managed tablespaces
Heather - Is there a particular reason the consultant is doing this other than maybe this is the first opportunity to learn this? Just my cynical side. Mentioning cynical, I was leery of the procedure to convert an existing dictionary-managed tablespace to a locally-managed one, but we production DBAs tend to be a conservative lot. If you go that route, be sure that you end up with uniform extents which I consider the best part of LMT.
Be sure to study the paper "How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation" by Himatsingka and Loaiza. before your consultant comes so that both of you agree on the approach to take. This is available on Oracle's Web site. The worst circumstance (see cynical above) would be for one person to create them and the other person to maintain them, but each with a different philosophy.
I think LMT and uniform extents and extensible tablespaces are the
greatest features Oracle has added recently.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, December 14, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
I have just heard today that an external consultant, who is coming to upgrade software for our Student Records system next week, wants to unload the live, test and training databases, and recreate them using locally managed tablespaces.
I've been reading all the incredibly positive things oracle have to say about this, but has anybody any real experience of using locally managed tablespaces, and if so, are there any major disadvantages or knock-on effects that I should be aware of? Apart from trying to find disk space to unload each database to do this, would it have any additional space implications?
Basically, I need to decide if I should let this go ahead.
Heather
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Docherty, Heather
INET: H.Docherty_at_napier.ac.uk
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).
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). Received on Fri Dec 14 2001 - 14:38:12 CST
 |
 |