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 <DWILLIAMS_at_LIFETOUCH.COM> 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.
> 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).
>
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Received on Mon Mar 24 2003 - 12:55:29 CST