RE: Management Reports

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Thu, 13 Jun 2002 08:29:01 -0800
Message-ID: <F001.0047D2E6.20020613082901@fatcity.com>

('binary' encoding is not supported, stored as-is)
Anything looking resolutely optimistic. Seriously, it means nothing. A database is not 'performant' per se, it's just layers of software easing the coding work to access and concurrently update data stored in file (sorry to be so down to earth). If developers have done a bad job, it will be slow, but do not blame the database. If you are attempting to manage terabytes of data on a second-hand machine which was an entry-level server 5 years ago, do not expect miracles either. The best you can do is provide 'availability' charts, showing when your database was up - you can getr this from the alert.log file. And check V$SQLAREA to get performance-killers - bad queries, that is. This is your insurance policy when your boss will come back to you saying 'users complain about DB performance' (IMHO it must already be the case, s/he wouldn't have thought about a report otherwise).

>----- Original Message -----
>From: "Vergara, Michael (TEM)"
><mvergara_at_guidant.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Thu, 13 Jun 2002 07:33:27
>
>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).
>===================================================
>========================
>---------------------------------------------------
>-----------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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).

Received on Thu Jun 13 2002 - 11:29:01 CDT