Hello all,
FWIW, I use managed in dictionary, no auto-extend, on an HP-UX, OPS 8.1.6.3
system. I considered locally managed (and auto vs. uniform), but as I have
extremely fast I/O, I could not justify pulling it out of the dictionary (no
problems of excessive $FET and $UET pinging). Now, that was 1 1/2 years ago,
so things may have changed. I am upgrading to 8.1.7.2.1 w/i the next month,
so I could use that time to switch over, if things have really changed.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, December 14, 2001 5:25 PM
To: Multiple recipients of list ORACLE-L
Hey Stephen - That's DENNIS damnit! And I didn't say that uniform extents
increase performance (I like autoextend and not getting awakened in the
middle of the night), but if anyone has evidence that they do, please share
it.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, December 14, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L
Heather:
Another thing to consider. If the vendor of your student application
system has not worked with LMTs, you may encounter support issues should you
have problems with database accessibility. I would verify that LMTs are
supported before converting.
In terms of usage, LMTs are great as they remove all of the ridiculous I/O
encountered by the SYSTEM tablespace for monitoring extent performance,
allocation, and deallocation. Denise is correct that uniform extents
significantly improve the performance of LMTs, however, multiple uniform
extent types can be used. However, if your extent sizes are all over the
map, you should create some uniform size and then move to LMT.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com
-----Original Message-----
Sent: Friday, December 14, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject: 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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Karniotis, Stephen
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Sherman, Paul R.
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
