RE: Management Reports

[Aponte, Tony]

Title: RE: Management Reports

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-----
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 12:26 PM
To: Aponte, Tony; [EMAIL PROTECTED]
Subject: RE: Management Reports

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-----
From: Aponte, Tony [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 8:33 AM
To: [EMAIL PROTECTED]
Cc: Vergara, Michael (TEM)
Subject: RE: Management Reports

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-----
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
Subject: Management Reports

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: [EMAIL PROTECTED]

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