【技术】通过v$sqlarea,v$sql查询最占用资源的查询

-----------------------
v$sqlarea,v$sql
-----------------------从V$SQLAREA中查询最占用资源的查询

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;

?

?