Re: Management Reports

From: Greg Moore <sqlgreg_at_pacbell.net>
Date: Fri, 14 Jun 2002 03:33:18 -0800
Message-ID: <F001.0047DE40.20020614033318@fatcity.com>

Keep the report short, just a page once a week, and have three key things highlighted -- your most important measurements of performance. People like to skim a report and focus on a few key things.

A good idea for these metrics just might be the three most critical business transactions. A performance report could show whether they complete in a timely manner, week after week. That's the definition of performance, right? Simply measure how long they take - perhaps via trace/TKPROF. Keep the detailed TKPROF reports in a notebook and just provide Elapsed Time Total number for the management report. You could have these three totals in three graphs, so as weeks go by they can watch the graphs fill in and see if they are taking more, less, or the same amount of time to complete.

Besides this there could be an optional "Other Items" section you sometimes include, in which you suggest ideas, report successes, or beg for more disk drives. ;-)

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Greg Moore
  INET: sqlgreg_at_pacbell.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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). Received on Fri Jun 14 2002 - 06:33:18 CDT