【技术】通过v$sqlarea,v$sql查询最占用资源的查询
select buffer_gets,sql_textfrom (select sql_text,buffer_gets, dense_rank() over (order by buffer_gets desc) buffer_gets_rank from v$sql)where buffer_gets_rank<=5;
?
