| 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: Reorganizing tables
Robert - I stand in awe of your insights (as always). Excellent suggestions.
Thank you.
I keep learning that the key to DBA success lies at least as much in the people skills ad the technical skills. There is a new book out, "The Art and Science of Oracle Performance Tuning" by Christopher Lawson. I notice that he spends almost as much time discussing the people aspects of tuning as the technical aspects.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, March 26, 2003 12:59 AM
To: Multiple recipients of list ORACLE-L
>> We have a new manager
My condolences.
With regards to re-orgs, you have already gotten a great number of suggestions. All I can add it this. I don't think there is for this, or many other questions, a black and white, yes or no answer. There are some good times that reorg's can be positive, particularly on older databases that have been perhaps.... mis-managed, in the past. Constant, weekly, re-orgs are harder to justify... to me if you have to do that then thats a sign of a bigger problem and you are solving a symptom not the disease.
Just to get your manager off your back, I'd do it once and make sure you generate lots of statistics, numbers and maybe even a graph or two. Tell your boss that you are going to baseline some queries from V$SQLAREA before and after and see if it makes a difference, bosses love numbers. Then give him this big THICK report with an executive summary at the front that says something like:
Database performance collapsed after the initial reorg and some administrative intervention was required. Due to this suggest not reorging the database.
Of course, what you WONT say is that the "administrative intervention" was the re-analyze of the tables that you had to do after the re-org.
What they don't know saves us Saturday work.
In a crafty state of mind at 1am on a Wed Morning,
Robert
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
-----Original Message-----
Sent: Monday, March 24, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
We have a new manager, and at his last employer the DBAs reorganize Oracle tables on a regular basis. I don't reorg tables on a regular basis. He is lobbying us to investigate this and test whether it would or wouldn't increase performance. We are on Oracle 8.1.6, Compaq Tru64, all tables are LMT with uniform extents. This is an OLTP system, but the users continue to add reports and the reports do quite a few full table scans. The reports are probably the critical performance issue at this time.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Wed Mar 26 2003 - 08:58:39 CST
 |
 |