Oracle-L: RE: Management Reports

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Fri, 14 Jun 2002 09:41:19 -0800
Message-ID: <F001.0047E4E2.20020614094119@fatcity.com>

I'm currently working on producing statistics for mid-managers. We have a lot of tools that collect statistics for our 30 production databases so my challenge it to map their individual repositories with the categories I want to report. But these are the categories I'm proposing, and they can be collected from v$ views and application tables:

Total CPU time used
DISK I/O counts
Network I/O counts
Session count (peak and average)
Total number of Oracle transactions
Total number of application transactions (the logical unit of work for the application. i.e. orders taken for our Order Entry app., packages shipped for Fulfillment, IVR calls, outbound calls placed, etc.)

HTH
Tony

-----Original Message-----
Sent: Thursday, June 13, 2002 12:26 PM
To: Aponte, Tony; ORACLE-L_at_fatcity.com

Tony:

Scorecard/historical. My management would not know what to make of a Spotlight screen if they sat on it.

Can I say that?

Mike

-----Original Message-----
Sent: Thursday, June 13, 2002 8:33 AM
To: ORACLE-L_at_fatcity.com
Cc: Vergara, Michael (TEM)

Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?)

Tony Aponte

-----Original Message-----
Sent: Thursday, June 13, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L

Good Morning Everyone!

My management wants a chart that shows the performance of the database. If this was your boss, what would you show them?

Thanks,
Mike

P.S. This is a repeat e-mail. I never saw my other one hit the list.

---

Michael P. Vergara
Oracle DBA
Guidant Corporation

--

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

Author: Vergara, Michael (TEM)
INET: mvergara_at_guidant.com

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).

--

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

Author: Aponte, Tony
INET: AponteT_at_hsn.net

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