root@sys 登陆查询
SELECT
/* MONITOR_AGENT */
svr_ip,
svr_port,
cpu_capacity_max AS cpu_total,
cpu_assigned_max AS cpu_assigned,
round(mem_capacity / 1024 / 1024 / 1024) mem_total_gb,
round(mem_assigned / 1024 / 1024 / 1024) mem_assigned_gb,
round((cpu_assigned_max / cpu_capacity_max), 2) AS cpu_assigned_percent,
round((mem_assigned / mem_capacity), 2) AS mem_assigned_percent,
round(data_disk_capacity / 1024 / 1024 / 1024) data_disk_capacity_gb,
round(data_disk_in_use / 1024 / 1024 / 1024) data_disk_in_use_gb,
round(
(data_disk_capacity - data_disk_in_use) / 1024 / 1024 / 1024
) data_disk_free_gb,
round(log_disk_capacity / 1024 / 1024 / 1024) log_disk_capacity_gb,
round(log_disk_assigned / 1024 / 1024 / 1024) log_disk_assigned_gb,
round(log_disk_in_use / 1024 / 1024 / 1024) log_disk_in_use_gb
FROM
gv$ob_servers
ORDER BY
svr_ip,
svr_port;
