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 understand.
select TO_CHAR(Created, 'YYYYMM') "MonthCreated", Count(TO_CHAR(Created, 'YYYYMM')) "TablesCreated"
from dba_objects
where object_type = 'TABLE'
group by TO_CHAR(Created, 'YYYYMM')
order by 1;
select TO_CHAR(LAST_DDL_TIME, 'YYYYMM') "MonthModified", Count(TO_CHAR(LAST_DDL_TIME, 'YYYYMM')) "Tables DDL'ed"
from dba_objects
where object_type = 'TABLE'
group by TO_CHAR(LAST_DDL_TIME, 'YYYYMM')
order by 1;
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Yuval Arnon [SMTP:[EMAIL PROTECTED]]
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 in advance!
Yuval.
Sr. DBA - WWF
