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. [EMAIL PROTECTED] -----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. - Do you do regular table reorgs? What benefit does that give you? - Are there any indicators of when a table reorg would be beneficial? - What sort of test would verify whether a table reorg changed performance? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] 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: [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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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).
