没有dm的老师回答吗？还是没有这个视图

看了下DBA手册，看下下面的满不满足需求：

select 
spn1.sql_id,
spn1.operation,
spn1.table_name,
spn1.table_alias,
sh1.top_sql_text,
sh1.time_used "time_used(us)",
sh1.exec_id,
sh1.start_time
from V$SQL_PLAN_NODE spn1 ,
v$sql_history sh1
where spn1.SQL_ID=sh1.SQL_ID and 
spn1.OPERATION like 'CSCN%'
order by start_time desc;