oracle查询-SQL缓存情况

select t.parsing_schema_name,t.sql_id,t.executions_total,t.disk_reads_total,t.parse_calls_total,to_char(substr(a.sql_text,1,1000))
from sys.wrh$_sqlstat t,sys.wrh$_sqltext a
where t.sql_id=a.sql_id