oracle运维查询占用物理读资源性能

1. 查询占用物理读资源性能分析

select sql_text,sql_id, disk_reads, buffer_gets, parsing_schema_name, executions
from v$sqlarea where parsing_schema_name='用户对象'
order by disk_reads desc;