-- 查询会话： SELECT status, type, COUNT(*) as value FROM v$session GROUP BY status, type; -- 查询资源使用情况： SELECT resource_name,current_utilization,CASE WHEN TRIM(limit_value) LIKE 'UNLIMITED' T