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.
dwilliams_at_lifetouch.com
Received on Mon Mar 24 2003 - 11:40:12 CST
