This type of request is entirely too common. The problem is that measuring
the "performance" of an Oracle system isn't like measuring the performance
of a car in the Indy 500 by timing laps, but that is typically the
perception of those asking. At my last employer, we developed
application-speci
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 ar
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 perf
your ass :-)
-Original Message-
Sent: 13 June 2002 16:33
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-ma
On a more serious note, I have had to do this for my damagement team at a
previous engagement.
They wanted a shell script to execute every 15 minutes, tell them how many
users were logged in (up to 2,500), and the timing for a simple query on
some customer table, for which they had benchmarked re
Give your damagers a Quest Spotlight monitor ! It has all the nice gui stuff
that damagers like to see, and they feel good about it. Plus it is different
colours, which gives them the illusion they actually know what is going on
inside and lets them think they are in control !
As for you, set up
LE-L <[EMAIL PROTECTED]>
cc:
Fax to:
Subject:RE: Management Reports
Mike,
My suggestion was silly, I agree. But it forces management to come up
with
a better question.
"How's the database running?" is as silly a question as you asking your
c
Mike,
My suggestion was silly, I agree. But it forces management to come up with
a better question.
"How's the database running?" is as silly a question as you asking your
child "How you feeling today?". Both answers are a flat "fine".
I would suggest you have a dialogue to ask what kind of in
Dennis,
I see your %OCP is growing!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, June 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Tom - I like your style! Hit 'em when they are asking for it. If he just
wants some color charts printed
LOL! But I'm already in the doghouse, so I don't think
they'd see it as funny!
-Original Message-
Sent: Thursday, June 13, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
hi!
select 1998, 'a lot to do' from dual;
select 1999, 'even more to do' from dual;
select 2000, 'ph ...
Title: 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
AMTo
Tom - I like your style! Hit 'em when they are asking for it. If he just
wants some color charts printed daily a creative solution from Don Burleson
in his "Oracle High-Performance Tuning with STATSPACK" book is to get the
statistics by doing queries on the STATSPACK tables and using grep and oth
)),'99')
"18",
to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'19',1,0)),'99')
"19",
to_char(sum(decode(substr(to_char(first_time,'HH24
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 slo
Title: 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
hi!
select 1998, 'a lot to do' from dual;
select 1999, 'even more to do' from dual;
select 2000, 'ph ' from dual;
select 2001, 'at full speed' from dual;
select 2002, 'increase the DBAs salary from dual';
my boss was delighted about it
daniel
"Vergara, Michael (TEM)" wrote:
>
> Go
Mike,
Get him the free version of Quests "Spotlight on Oracle". Puts a pretty
interactive chart up on his screen. Green means good. Yellow means caution,
Pink means almost danger. Red means bad.
This should be a good start for him! :)
Tom Mercadante
Oracle Certified Professional
-Orig
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.
---
=
18 matches
Mail list logo