Dennis,
We don't re-org tables, but we do rebuild indexes on occassion.
Dick Goulet
____________________Reply Separator____________________
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date: 3/24/2003 9:38 AM
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:
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).
