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