| 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: [resend] multiple extents are OK,
Jerry,
Multiple extents is not a problem, true.
But you could put in some "consulting" effort to resize the extents ---
recreate the
tablespaces (or at least those tables which suffer full-table scans) with
uniform-sized extents where the extent size is a proper multiple of the
max_io size --
that way you can reduce the I/O calls for FTSs, do some
export/import/rebuilding,
keep your client happy (tell them about extent-sizes rather than number of
extents)
and earn some $$.
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> 18/01/2002 09:55 AM Sent by: root_at_fatcity.com
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
Subject: RE: multiple extents are OK, dagnabbit!
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.
dwilliams_at_lifetouch.com
-----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!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM 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-LReceived on Thu Jan 17 2002 - 22:04:55 CST
(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: INET: hemantchitale_at_charteredsemi.com 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).
 |
 |