oracle 性能监测语句

select temp.*
  from (select t.MODULE 进程,
               t.PARSING_SCHEMA_NAME 用户,
               t.EXECUTIONS 执行次数,
               trunc(t.CPU_TIME / 1000 / 1000 / t.EXECUTIONS, 5) 平均时间,
               t.OPTIMIZER_MODE 优化方式,
               t.SQL_TEXT Sql语句,
               t.CPU_TIME / 1000 / 1000 CPU_TIME,
               t.DISK_READS 读盘次数,
               decode(t.COMMAND_TYPE,
                      3,
                      'select',
                      2,
                      'insert',
                      6,
                      'update',
                      7,
                      'delete',
                      'plsql') 命令类型,
               t.SQL_FULLTEXT 完整sql,
               t.SHARABLE_MEM 占用sharedpool内存,
               t.BUFFER_GETS 读取缓冲区的次数
          from V$SQLAREA t
         where t.EXECUTIONS > 0
           and t.PARSING_USER_ID not in (0, 51)) temp
order by temp.平均时间 desc, temp.执行次数 desc