have you done a 10046 trace (yes Cary, I listen to you!) on one of the reports to see why/if there is a performance problem and if there is one, where it is?
one sentence bothers me "the users continue to add reports" -- who writes the SQL for these reports? Is it as efficient as it could be? While FTS is not necessarily wrong, how large are the tables that are being read? --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > 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). > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
