Jerry - You could approach the issue a little more subtly. Here is an Oracle
paper where Oracle recommends locally managed tablespaces and uniform
extents. If you can point out to them that you are a modern DBA that is
keeping up with new Oracle features, I think that would be persuasive.
http://www.oracle.com/collateral/o8i_high_avail_enhance_fo.pdf
<http://www.oracle.com/collateral/o8i_high_avail_enhance_fo.pdf>
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, January 17, 2002 7:40 PM
To: '[EMAIL PROTECTED]'
Jerry - Maybe I'm missing something here. Since you refer to them as a
"client", you must have a consulting relationship with them - right? So if
you rebuild the tables, you get more money - right? So you rebuild the
tables, the client is happy, and you are a little wealthier - right? Or
maybe you are too wealthy as it is, with more work than you can handle. Then
you solicit help from others on this list to be your trusted assistant that
will rebuild the tables, explaining to the client that you are overqualified
for such a mundane task.
I'm teasing you, but the older I get, the more I see that sometimes we
computer folk are our own worst enemy. There is such a thing as being
technically right but losing the client anyway. By the way, I totally agree
with you on the multiple extents issue, but since Oracle was nice enough to
post the paper "Stop Defragmenting . . " on their web site, that seems to
have convinced the manager that wanted to hear something from the vendor
before he would believe it. In my case I'm an employee, so it would just cut
into my weekends. Good luck, but don't forget the "softer" skills.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, January 17, 2002 3:46 PM
To: Multiple recipients of list ORACLE-L
Hi there -
I'm trying to convince a client that multiple extents for a table will not
hurt their performance. It's a PeopleSoft app, and PeopleSoft is telling
them that they need to reorg any object with greater than 10 extents (even
indexes). This Oracle 8.1.6.
I've referenced the "How to Stop Defragmenting and Start Living: The
Definitive Word on Fragmentation" white paper by Bhaskar Himatsingka and
Juan Loaiza of Oracle. That didn't convince them. I tried to explain that
Oracle reads BUFFERS and not extents, etc., but that didn't work.
I'm about to open a vein.
Does anybody have any references that they can point me to? (Something from
PeopleSoft would be ideal, though I would be suprised if it existed.) I read
a rant on somebody's web site a while back that was really good, but alas I
cannot remember his name or URL. (I blame my kids for my failing memory).
Thanks!
- Jerry
--
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).
