Grid Control - Alerts By type

Well and now, getting the information for all the [same] alerts across all targeted databases, you can use the following query (knowing the view, it is easy to get the rest of the different types of information). For this specific query I wanted the invalid objects order by number. Example:
"237 object(s) are invalid in the PUBLIC schema."


If you check the MGMT$ views on the sysman schema, you get all the necessary information. After this post:
http://pinelasgarden.blogspot.co.uk/2012/06/grid-control-target-databases-size.html
I leave you with the following query (the message_params field has the varying  info).



select target_name, message_params,message
from MGMT$ALERT_CURRENT 
where target_type='oracle_database'
and metric_name='invalid_objects'
order by to_number(substr(message_params,1,instr(message_params,'&')-1)) desc;

Grid Control - Target Databases Size Report

After going through all the MGMT$ views in the sysman schema, I finally found out how to get the size of all monitored targets (oracle databases) in a single table (I was only given access to GC and not any DB).
And after that, how to create a report based on that query in Grid Control (10g).
So here are the steps to create a report and the query for the report. 


Basically you go to reports, click create, add a "table from sql" element then you edit the element and paste the sql statement and with that and one or two more slight touches (names and so forth), you are good to go.

And the query is:

select host_name,target_name, 

ROUND(sum(tablespace_size)/1024/1024/1024,1) totalGB,

round(sum(tablespace_used_size)/1024/1024/1024,1) usedGB,

round((sum(tablespace_used_size))/(sum(tablespace_size))*100,1) usedPerc

From MGMT$DB_TABLESPACES

group by host_name,target_name order by 5 desc

This gives you the host and target name, the total GB allocated, the used GB, and the used percentage.

Cloud Computing; is it real or just a new name of the same game?

Um artigo interessante sobre cloud computing

http://blogs.oracle.com/raulgoy/2011/04/cloud_computing_is_it_real_or.html