V$METRIGROUP-11g性能监控与调整的视图示例

查询V$METRIGROUP tV$metricgroup：实例统计信息SQL> 根据interval_size排序，显示名称和间隔大小；名称 间隔大小 ---- ---- Service Metrics (Short) 500 WLM PC Metrics 500 Session Metrics Short Duration 1500 System Metrics Short Duration 1500 WCR metrics 6000 Session Metrics Long Duration 6000 Event Class Metrics 6000 Service Metrics 6000 System Metrics Long Duration 6000 Tablespace Metrics Long Duration 6000 Event Metrics 6000 Resource Manager Stats 6000 I/O Stats by Function Metrics 6000 File Metrics Long Duration 60000已选择14行。