Ron,
I agree, uniform sizing is best. I hardly ever use automatic except for small
development databases and small "MISC" tablespaces and even then I think "Why
didn't I use use uniform 64K ?"
Cheers,
Chris
Quoting Ron Rogers <[EMAIL PROTECTED]>:
> Brad,
> For LMT's I prefer uniform sizing
We need to start moving these discussions to freelists per Jared's note.
Brad - I agree with Ron. I think it is critical to read "How to quit
defragmenting . . ." before making the change to ensure you clearly
understand the concepts and receive the benefits. If someone on the list
knows of a more
Jonathan
Thanks so much for posting this excellent article. Very high quality as
all your writing is. This was my devious purpose in replying, in hopes
something like this was out there.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January
Johnathan,
Very interesting article. I especially like the parts where it is not
our fault it is designed that way. I agree that with proper thought and
trial, a lot of perceived performance issues can be eliminated or
minimized.
I could really use the compress option, I guess that I will have to
Jonathan:
I'd go a bit further than that. Your article is
fantasitic.
I've read "How to stop defrag ..." several times. It
just never clicked for me.
I've been migrating to LMT using your article, and
it's been great. It's crystal-clear, and I really
appreciate the examples.
Thanks!
Barb
---
I think
http://www.jlcomp.demon.co.uk/08_lmt.doc
is pretty good, but I'm biased.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearanc
We need to start moving these discussions to freelists per Jared's note.
Brad - I agree with Ron. I think it is critical to read "How to quit
defragmenting . . ." before making the change to ensure you clearly
understand the concepts and receive the benefits. If someone on the list
knows of a more
Brad,
For LMT's I prefer uniform sizing that I can define to meet the needs
of the data. If you use automatic the extend sizes will change
drimatically as the number if extends increase. With a little planning
you can have little waste in the tablespace and use the tablespace for
multiple tables o
for LMTs...
Advantages in uniform versus automatic?
Uniform 5 MB? 10 MB.100MB etc
thoughts would be appreciatd
Thanks
Brad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Odland, Brad
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-