Title: Database Metrics
Hello Yuval Arnon
I will use three graphs:
1) Number of SQL statements executed per
day.
2) Mean response time.
2) CPU usage per day.
In both cases add a reference point that is the
mean of the last 30-40 days
so they can see any abnormal behavior.
The space
Title: Database Metrics
Hi,
I am looking for ideas on what kind of metrics the DBA group should provide the management on a weekly basis so they can understand how the databases are evolving over time.
These metrics should be simple enough as the management is not Oracle savvy.
Thanks
A few idears...
Summarize total database size growth (growth of the actual data, not the
object) and deltas by tablespace.
Summarize actual object growth (object as opposed to size, contrast against
overall total tablespace space) and deltas.
Create a benchmark query that runs at various
Robert - Excellent ideas! To bounce off your ideas, one thought is to find
out what matters most to the users and create some statistics based on that.
For example, one of our applications has a process that performs really
badly during the peak season. Some fixes have been tried, but management
Title: RE: Database Metrics
I use these two to show the number of tables created and tables modified by month. In our case, the number of new tables and DDLs has been climbing as the database is getting more complex. On a graph, the lines are climbing upward which is something management can