Ask yourself what he wants them for. 1) to see how you are doing your job,
2) to see if your work load is increasing or decreasing, 3) to see if the
databases/machines will need to be upgraded/replaced. I would think some
basic metrics would include:
Machine / DB metrics:
Machine uptime, DB uptime, Average Load (work hours and off hours), Peak
load.
Load would be based on CPU, memory, network and disk usage.
Disk space usage (growth).
Backup performance (how long does it take - is the length of time
increasing)
Sar can collect this stuff easily enough. You can then parse it easily
enough to break out work hours from off hours.
DBA tasks:
# requests for service / # of problems encountered
Amount of time to service each
Cause / resolution of each
Actions taken to ensure they did not re-occur.
You could automate your notes into a table or somesuch to provide this.
j.
-----Original Message-----
From: olm
[mailto:oracledba-ezmlmshield-x6470189.[Email address protected]
Sent: Tuesday, April 03, 2007 1:16 AM
To: LazyDBA Discussion
Subject: Re: Dba metrics
Hi Brian,
You can send a report containing information like cpu usage, no of active
sessions, disk usage, vmstat and tablespace usage , patches applied, any
logs cleared etc.,
Srinivas
"Zelli Brian " <oracledba-ezmlmshield-x96497564.[Email address protected]
04/03/2007 01:43 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Dba metrics
Our boss just asked us for "metrics" on our work. Has anybody else ever
been asked this and if so share what they report on as to what is
considered measurable for a DBA? I guess it would be on a day-to-day
basis.....
ciao,
Brian
This email message may contain legally privileged and/or confidential
information. If you are not the intended recipient(s), or the employee or
agent responsible for the delivery of this message to the intended
recipient(s), you are hereby notified that any disclosure, copying,
distribution, or use of this email message is prohibited. If you have
received this message in error, please notify the sender immediately by
e-mail and delete this email message from your computer. Thank you.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-mail and any files transmitted with it are for the sole use of the
intended
recipient(s) and may contain confidential and privileged information. If you
are
not the intended recipient, please contact the sender by reply e-mail and
destroy
all copies and the original message. Any unauthorized review, use,
disclosure,
dissemination, forwarding, printing or copying of this email or any action
taken
in reliance on this e-mail is strictly prohibited and may be unlawful.The
recipient
acknowledges that Bharti Airtel Limited or its subsidiaries and associated
companies(collectively "Bharti Airtel Limited"),
are unable to exercise control or ensure or guarantee the integrity
of/overthe contents
of the information contained in e-mail transmissions and further
acknowledges that any views
expressed in this message are those of the individual sender and no binding
nature of the
message shall be implied or assumed unless the sender does so expressly with
due authority of Bharti Airtel Limited.
Before opening any attachments please check them for viruses and defects.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page