Oralce Enterprise Manager - How to create custom reports and dashboards
I have a unique situation. We get a report every week from our DBA offshore support with the following statistics:
1. Table space usage
TABLESPACE_NAME MB_ALLOCATED MB_FREE MB_USED TOT_PCT_FREE TOT_PCT_USED MAX_SIZE_MB
for all tables spaces
2. ASM Usage
State Type Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
See the above statistics.
I would like to know, using oracle Enterprise Manager ( a GUI for tracking Oracle DB stats), Is it possible to create a dashboard/graph on Enterprise Manager (EM). I know it allows custom reports and alerts to be created. My idea is to create a dashboard with the above information including history of the above and create alerts if it crosses certain limits. My knowledge is limited and need some input from those skilled.
Currently I am putting this information in Excel and creating a graph manually. As you can see, it is going to be a tedious soon, would liike to find a way where I could get this information automatically.
If it is possible to create a graph/dashboard with historic data using oracle EM, what are all the steps I need to take? I just need to have brief idea so that I can work with my team to implement the same
Please let me know
Edited by: Chandra U on Apr 14, 2011 10:07 AM